Index and Match Problem

[ismailzkhan]

Hi Excel Experts,

Pls help me to figure a formula to lookup and match specific text.

Attached Excel sheet for better understanding.

Thanks in advance!!

Regards,
Ismail Khan

 

[Asheesh]

Hi,

Use the below in J3 and drag it down

VLOOKUP(H3,$B$3:$C$16295,2,0)

 

[Xiq]

Hi ismailzkhan,

Please see attached file.

 

[ismailzkhan]

Hi ismailzkhan,

Please see attached file.

Dear Xiq,

Works like charm. Thanks..

It takes a while for me to understand this formula


Regards,
Ismail Khan