VLOOKUP & FIND hybrid

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I need a VLOOKUP function that does not require an exact
match to return true. I would like the function to return
true if the lookup value is found anywhere within any of
the cells within the lookup array.

VLOOKUP - works on exact cell matches.

FIND - works with single cells and not arrays.

Can anyone help?

Many Thanks,
Simon
 
Hi Simon
try something like the following array formula (entered with
CTRL+SHIFT+ENTER)
=INDEX(B1:B100,MATCH(TRUE,ISNUMBER(FIND("value",A1:A100)),0))
 
Back
Top