Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table field types | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Drop time in date/time field | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |