I think the wild card suggestion will work.

anitadai wrote:

Change your "false" to true, or leave it blank. Then sort your look up table
by column 1.

anitadai

"Dave Peterson" wrote:

=vlookup(e2&"*",$b$2:$e$1957,3,false)

or maybe

=vlookup(left(e2,5)&"*",$b$2:$e$1957,3,false)





Wannabe Efficient wrote:

I have managed to figure out how to use the Vlookup command to find
information in a column and to return information using the following
formula:

In this example, I find two like values and return some data or a message -
=IF(ISNA(VLOOKUP(E2,$B$2:$E$1957,3,FALSE))=TRUE, "Product Number is not
found", VLOOKUP(E2,$B$2:$E$1957,3,FALSE))

However, I need to understand how to find T1234 in list that contains
T1234_TEST, I want the lookup command to match the "T1234" portion of the
project name. Is there some way to key on the first 5 characters and
consider this a match? In the earlier example, it was easy to find the value
with the exact name - this is a bit more tricky..

Please help

FACTS:
Lookup Value = T1234
Table Array = T1234_Test
The problem is the N/A is return and I need it to be smart enough to say,
yes we've matched the first 5 characters in T1234_Test.

--

Dave Peterson


--

Dave Peterson