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