Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting data from a combination of columns & rows.
I have a sheet that has 3 catagories & data listed columns beneath
(B&F,PM & QA), see below AC AD AE AF AG AH AI B&F PM QA .5 door 4.4 .5 door 3.4 1 door 2.4 1 door 4.4 1 door 3.4 2 door 2.4 2 door 4.4 2 door 3.4 air curtain 6.4 3 door 4.4 3 door 3.4 other 4.4 i have created 2 dropdown lists which i select, see below B&F, then select 1 door. excel should then display 4.4 OR QA, then secect 2 door. excel should then display 2.4.etc... A1 A2 A4 Call Type Product Points B&F 1 door 4.4 QA 2 door 2.4 PM FCB 12.4 i'm thinking of a combination HLOOKUP, VLOOKUP & Filtering Can anyone provide a forumla that gives me my required result? Thank You in anticipation. -- Browny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting non consectutive cells/rows/columns in excel 2007 | Excel Discussion (Misc queries) | |||
include more than 3 data series as columns in combination chart | Charts and Charting in Excel | |||
Selecting All Rows with Certain Data | Excel Discussion (Misc queries) | |||
Selecting All Rows with Certain Data | Excel Discussion (Misc queries) | |||
Selecting All Rows with Certain Data | Excel Discussion (Misc queries) |