Log In
Register
Home
September 18, 2019
Offline
Hello,
I am facing a problem in vlookup formula. Once I enter in the cell value of table array of vlookup formula and press enter then formula works properly. My sheet of query is attached. i explain the query in attached file.
Thanks in advance for your cooperation.
Waqas Munir
See Answer
VIP
Trusted Members
December 7, 2016
Offline
Hello Waqas,
The problem here is that all values in cells C3 to C21, except for the value in cell C16, are text. The values you check against are numbers, so VLOOKUP don't find a match, except for the third lookup that is working fine because the value in cell C16 and the comparison value in cell J9 are numbers.
Either you correct the values in column C to be number values or you change comparison values in column K to be text (just remember then to change the value in cell C16 to text).
If you have problem to visually see if the values are formatted as text or numbers, you can for example use the ISNUMBER or ISTEXT functions to do a simple check.
Br,
Anders
September 18, 2019
Offline
No...
my problem is not resolved please downloads the attached file and apply any thing to resolve it.
Thanks in advance for your cooperation.
Trusted Members
Moderators
November 1, 2018
Offline
To cater for either format you could use:
=IFERROR(VLOOKUP(TEXT(J4,"0"),C:D,2,0),VLOOKUP(J4,C:D,2,0))
Answers Post
1 Guest(s)
