Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to pull info from sheet 2 to a table to sheet
sheet1 b 1 2 3 Qty Size Type sheet2 variable1 variable2 Qty Size Type a 1 2 1 trc a 2 4 1.5 cb a 3 3 4 cpb b 1 5 0.5 ckb b 2 3 0.75 cb b 3 4 2 trc I need the result to return the values for the qty, size, type for variable 2 for variable 1 b <-(variable) 1 2 3 Qty (5) (3) (4) Size (.5) (.75) (2) Type (ckb) (cb) (trc) any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |