That second formula needs to be changed to this:
=IF(ISNA(VLOOKUP("T1234*",$B$2:$E$1957,3,0)),"Prod uct Number is not
found",VLOOKUP("T1234*",$B$2:$E$1957,3,0))
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
First of all, you *don't* need the " =TRUE " in your formula.
Next ... is the " T1234 " in E2... or do you intend to "hard code" it into
the formula itself?
If it's in cell E2, try this:
=IF(ISNA(VLOOKUP(E2&"*",$B$2:$E$1957,3,0)),"Produc t Number is not
found",VLOOKUP(E2&"*",$B$2:$E$1957,3,0))
If you're going to hard code it, try this:
=IF(ISNA(VLOOKUP("T1234*",$B$2:$E$1957,3,0)),"Prod uct Number is not
found",VLOOKUP(E2&"*",$B$2:$E$1957,3,0))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Wannabe Efficient" <Wannabe wrote in
message ...
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.