VLookUp Problems

T

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
 
B

BenjieLop

tiab86 said:
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 ?
Click to expand...

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
 
T

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
 
Top