looking up values with a corresponding label

[sfinns]

I want to build a look up table but am having problems that looks up a label and inserts teh value in a next door cell see below and onteh attached sheet - please help


THD US Equity look up thd us and insert value here ie 0.23%
EWH US Equity look up ewh us and insert value here ie -1.13%
fxi US Equity look up fxi us and insert value here ie -1.13%




stock FXI US Equity EWH US Equity INP US Equity bkf us equity THD US Equity
price -2.81% -1.13% -1.49% -1.85% 0.23%

[mehmetcik]

Hi

I have amended your sheet as requested.

Enjoy.