vlookup and text

J

John S

howdy. i need to place data in a specific cell by looking
up data from a range. some vlookup will contain both
numbers and letters (example, 123a). how can i write the
formula to look up alpha numerics? here is the formula i
am currently using:

=IF(V13="","",VLOOKUP(V13,Input!$A$39:$D$239,4,FALSE))

thanx for you help
 
K

Kevin M

John, the formula is correct, the only thing to keep in
mind regarding VLOOKUPs is that it will search for the
exact text, numeric or otherwise that the user types in
V13.

HTH,
Kevin M
 
N

Nick Hodge

John

No with you I'm afraid. The formula you are using will look up *any* value
in V13 in the 'lookup' table. It matters nothing if it is numeric, text or
a mix. It is just (in your case (FALSE)), looking for an exact match

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
J

John S

thanks to Nick Hodge for his help.
-----Original Message-----
John

No with you I'm afraid. The formula you are using will look up *any* value
in V13 in the 'lookup' table. It matters nothing if it is numeric, text or
a mix. It is just (in your case (FALSE)), looking for an exact match

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]





.
Click to expand...
 
Top