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
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
No...
my problem is not resolved please downloads the attached file and apply any thing to resolve it.
Thanks in advance for your cooperation.
To cater for either format you could use:
=IFERROR(VLOOKUP(TEXT(J4,"0"),C:D,2,0),VLOOKUP(J4,C:D,2,0))
Still better to ensure you have correct data. See attached.
Thanks Mr Anders Sehistedt and Velouria... Both answers are equally perfect.
