Vlookup / hlookup

Greeting,

First of all, I had tried SEARCH function. However, most samples are being used in .xlsx, while I do not have the access of that file. So if there's any sample reply, please use .xls.

I managed to learn the use of HLOOKUP, =HLOOKUP(F2,B:E,2,FALSE)
However, it's impossible for me to type in manually for 10k of entries.
I'm seeking for a solution to click and drag for fill in for the rest of the row.

Appreciate any helps, or even better if there's any other formula I could use here.

p/s : i had a feeling i need to use INDEX and MATCH function?


Thanks and Regards.