Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookups
I would like to combine the data in columns B, C, D, and E contained
on the "Sales" worksheet with the data on the "Inventory" worksheet, when the part_numbers in column A are a match. What formula would give me results as shown in the example? TIA Sales ws: A B C D E A123 1.3 1.4 1.5 1.6 A124 0.8 1.1 1.5 2.1 12Q3 1.0 1.1 1.2 3.5 Inventory ws: A B C D E F G A110 43 yes A125 5 yes 12Q3 1.0 1.1 1.2 3.5 12 no |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups and ifs! | Excel Worksheet Functions | |||
Lookups | Excel Discussion (Misc queries) | |||
Lookups? | Excel Discussion (Misc queries) | |||
need help with V lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |