Matching partly

[Maia]

Hello,

I know the lookup functions in Excel, but how can I make a lookup that would
make a partly "match" with formulas. Example:
code ABC123 would match to ABC1234567 because the criteria can be found as a
part of the found item?

Maia

 

[Paul Falla]

Dear Maia
Try setting the last part of your lookup formula to TRUE -
EG HLOOKUP(B1,A1:A100,TRUE) - The FALSE part of the
formula forces Excel to look for an exact match, whereas
TRUE looks for a 'close' match.

Hope this helps

Paul Falla

 

[Frank Kabel]

Hi
try something like the following array formula (entered with
CTRL+SHIFT+ENTER)
=INDEX($B$1:$B$100,MATCH(TRUE,ISNUMBER(FIND("ABC123",$A$1:$A$100)),0))

This searches for "ABC123" in column A and returns the value from
column B