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