Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup multiple terms and return one value
I'm having some difficulties getting this done. I would like to lookup values
in first two columns (category and sub category) in a range in a separate table with 3 columns (match first two columns in first sheet to first two columns in second table, and if both matches, return value in column 3 in the second table). First sheet will contain data over 2000 rows, while the lookup table contains a fixed 3 columns by 150 rows. example: Prod Sub Hours D | 1 2 3 | A a1 120 | A a1 2 A a2 180 | A a2 1 B b1 140 | B b1 4 B b1 160 | B b1 4 C c1 200 | C c1 3 Any help is greatly appreciated. Thanks. -- when u change the way u look @ things, the things u look at change. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Multiple Conditions Query | Excel Worksheet Functions |