lookups

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
 
Back
Top