Match across multiple ranges

[bth456]

Hi Guys

I have been struggling with this one for a while, please help.

i know one of you will just smash it in seconds its so easy, its pretty self explanatory when you see how i have laid out the table.

i obviously have a much bigger table to adapt formula to with a large product list.

i just want price to appear in price after the selections have been made.

thank you for your help.



i am a Pakled, so you are Geordi La Forge

[Glenn Kennedy]

Hi. Your thread title was awful. Please re-read rule 1. On THIS occasion, I have changed it for you.

=INDEX(($C$5:$F$7,$G$5:$J$7),MATCH(L7,$B$5:$B$7,0),MATCH(N7,$C$4:$F$4,0),IF(M7="No",1,2))

see sheet.

[bth456]

Hi. Your thread title was awful. Please re-read rule 1. On THIS occasion, I have changed it for you.

=INDEX(($C$5:$F$7,$G$5:$J$7),MATCH(L7,$B$5:$B$7,0),MATCH(N7,$C$4:$F$4,0),IF(M7="No",1,2))

see sheet.

thank you very much, thats great.

If i cant use star trek refrences on a excel forum where can i?

[Glenn Kennedy]

Lol. Star Trek references are OK anywhere, except in the title. I was watching the originsl series on UK Horror channel, just before I replied to you.

Live ling and prosper.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[Glenn Kennedy]

Live ling!??? Idiot.