W
Wannabe Efficient
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.
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.