look up more than 1 field
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
|