VLookUp Problems

[tiab86]

I am trying to use the VLookUp option in a spread sheet and can get i
to work except for when the value that I am looking for is a letter
How can I make the formula return the correct value

 

[olasa]

Since it should work, could you give an example when it's not working

 

[BenjieLop]

I am trying to use the VLookUp option in a spread sheet and can get i
to work except for when the value that I am looking for is a letter
How can I make the formula return the correct value ?

Will this work for you?

=vlookup(A1,$B$1:$C$100,2,*False*)

Note that I simply added the argument "False" in the VLookup formula
Maybe adding the argument "False" in your formula will help you out.

Regards

 

[tiab86]

Thanks Benjie,

That fixed my problems.
What was happening was the return value that I was getting was th
value in the last cell of the array. For example
=VLOOKUP(C697,InventoryCtrl!A2:F175,6) was returning the value in F17
regardless if the lookup value was in the Table Array. When I put th
False in the formula: =VLOOKUP(C697,InventoryCtrl!A2:F175,6,FALSE) i
worked fine. Now it will also work, where it wouldn't be for, jus
selecting all the columns: =VLOOKUP(C697,InventoryCtrl!A:F,6,FALSE)
which what I originally wanted.


Thanks Again

tiab8