Add a new column on the left edge of your table and therein CONCATENATE the
month and currency into that one column.......then use it to lookup the
"concatenated" month and currency you are questioning........this way you
can "look up two things at once", so to speak.

Vaya con Dios,
Chuck, CABGx3


"mango" wrote in message
...
dear all,
how to use lookup function to look into 'table' by checking if month and
currency can match then i will take the rate out from 'table' and put in
'list'.
if cannot any suggestion? vlookup only allows 1 parameter. but now i need
to
match more than 1 field. how?
please help.


list
mth cur amt curr
Jan Pound 200 2.3 460
Feb USD 450 1.3 585


table
mth curr rate
Jan USD 1.2
Jan Pound 2.3
Jan HKD 1.1
Feb USD 1.3
Feb Pound 2.1
Feb HKD 1.0