lookups

[Tom]

Interesting formula...

is there a way to use a wildcard in the VLOOKUP array?

For instance, in the 1st column of the array, I like to
place cell address values (e.g. "$A$*" that would be
picked up when e.g. another cell is either e.g. "$A$24"
or "$A$65").

Thanks!

Tom

 

[Suresh Nair]

Tom

Your requirement is not very clear but i suppose u know
the logic behind ur question. However focusing on your
question pls try the below:-
=IF(ISERROR(VLOOKUP(A4&"*",B3:C6,2,FALSE)),"not
found",VLOOKUP(A4&"*",B3:C6,2,0))
As mentioned earlier the criteria and range is an
assumption.Goodluck!
HTH
Suresh Nair