Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLookup and If Functions
How do I pull data from incoming data worksheet to destination wksht?
1st worksheet (destination) M-YY Product 1 label 1 Criteria 1 LOB1 Product 1 label 1 Criteria 2 LOB1 Product 1 label 1 Criteria 3 LOB1 Product 1 label 1 Criteria 4 LOB1 Product 1 label 1 Criteria 5 LOB1 Product 1 label 1 Criteria 6 LOB1 Product 1 label 1 Criteria 7 LOB1 Product 1 label 1 Criteria 8 LOB1 Product 1 label 2 Criteria 1 LOB1 Product 1 label 2 Criteria 2 LOB1 Product 1 label 2 Criteria 3 LOB1 Product 1 label 2 Criteria 4 LOB1 Product 1 label 2 Criteria 5 LOB1 Product 1 label 2 Criteria 6 LOB1 Product 1 label 2 Criteria 7 LOB1 Product 1 label 2 Criteria 8 LOB1 2nd worksheet (incoming data) label 1 label 2 and so on product 1 Criteria 1 LOB1 1 product 2 Criteria 2 LOB2 2 product 3 Criteria 3 LOB1 3 product 4 Criteria 4 LOB2 4 product 5 Criteria 5 LOB1 5 product 1 Criteria 6 LOB2 6 product 2 Criteria 7 LOB1 7 product 3 Criteria 8 LOB2 8 product 4 Criteria 1 LOB1 9 product 5 Criteria 2 LOB2 10 product 1 Criteria 3 LOB1 11 product 2 Criteria 4 LOB2 12 product 3 Criteria 5 LOB1 13 product 4 Criteria 6 LOB2 14 product 5 Criteria 7 LOB1 15 product 1 Criteria 8 LOB2 16 -- MF |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Hlookup/max value? | Excel Worksheet Functions | |||
How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |