I am trying to use the VLookUp option in a spread sheet and can get it
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 ?


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=390403

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


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390403

tiab86 Wrote:
I am trying to use the VLookUp option in a spread sheet and can get it
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=390403

Thanks Benjie,

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


Thanks Again

tiab86


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=390403