Hi
I know this is simple (not to me) I have tried various formula, vlookup and index and match, I have searched on this forum too but can not find quite what I want, I have 3 drop down boxes, 3 criteria to match in order to retrieve the data from the matched row, hope the attached workbook will explain it better
Thanks
J
Try this array formula in O8 and pull formula to the right
=INDEX(D:D,IF(($A$1:$A$48=$O$1)*($B$1:$B$48=$O$2),MATCH($O$3,$C$2:$C$48,0)+1))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Last edited by AlKey; 11-22-2014 at 12:59 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Adjusted formula
=INDEX(D$2:D$48,IF(($A$1:$A$48=$O$1)*($B$1:$B$48=$O$2),MATCH($O$3,$C$2:$C$48,0)))
Thank you AlKey, The formula works great for the first block of data (Tandem) (28") but when I use the drop downs to choose (Single) or (12)" then it does not work, thank you for your help
Is it my PC acting up - or is this sheet calculating really slowly...
Try this.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Wind the handle Glen crank your PC up, many thanks, looks like that has worked, so all you did was drag the criteria down for each row? thanks again
No, I also redid the formulas to the style that I prefer....
ahh yes I see that now, thank you have a good evening
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks