selecting data from a combination of columns & rows.
Try this in cell under Points and fill it down as necessary:
=VLOOKUP(B2,OFFSET(AD1,0,MATCH(A2,$AD$1:$AH$1,0)-1,5,2),2,FALSE)
In OFFSET(AD1,0,MATCH(A2,$AD$1:$AH$1,0)-1,5,2) replace 5 by the real number
of rows of your 1st table!
Regards,
Stefi
€žBrowny€ť ezt Ă*rta:
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
|