Lookup problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a table like
Row1 Col A Col B Col C Col
Row2 YTD Last month YTD Feb-0
Row3 CME CME CM
Row4 Hongkong 10 6
Row5 Shanghai 20 13

I want to set the formula to return the value of CME of Feb-04 for Hongkong i.e. 4, Please help

thanks.
 
Hi Janmy!

It may be how it has come out but you need to explain why CME should return
Feb-04. HongKong is 4 is OK And Shanghai of 7 would be OK but...

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Janmy

=VLOOKUP(A1,$A$4:$D$5,4,0

A1 is the value you want to look up
$A$4:$D$5 is the lookup range (you can expand this
4 is the column number ( to lookup last month CME put a 3

Regards
Alby
 
Hi,
Yes, it's a large worksheet with not just CME but also other categories.
Thanks and regards.
 
Back
Top