Partial match sheet1 in sheet2 get columnB

[satish78]

Hi Friends,

I am trying to do partial match but its not pulling correct abbreviations.

Attached sample file.
Used this formula but did not pull right one.
[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64, align: left"]
#=VLOOKUP(F1&"*",Sheet2!A:B,2)
[/TD]
[/TR]
</tbody>[/TABLE]


https://spaces.hightail.com/space/M8AAa4mCKO

 

[bosco_yip]

Try,

In G1, copied down :

=LOOKUP(1,-SEARCH(Sheet2!A$1:A$8,F1),Sheet2!B$1:B$8)

Regards
Bosco

 

[MUKESHY12390]

Here you go..

Just copy and paste it to sheet1

=IFERROR(VLOOKUP(TRIM(MID($F1,SEARCH(",",$F1,1)+1,LEN($F1)-SEARCH(",",$F1,1)+1)),Sheet2!$A:$B,2,0),VLOOKUP(TRIM(MID($F1,1,LEN($F1)-SEARCH(",",$F1,1))),Sheet2!$A:$B,2,0))

 

[satish78]

Try,

In G1, copied down :

=LOOKUP(1,-SEARCH(Sheet2!A$1:A$8,F1),Sheet2!B$1:B$8)

Regards
Bosco

Great! It worked.

Thank you