vlookup/match/index function?

Ok so right now I have two formulas that I am using as I have two different charts.

In cell D3: =VLOOKUP(B1,B8:G11,HLOOKUP(C3,B6:G7,2,FALSE),FALSE)
Using the data in B6:G11

In cell D4: =INDEX(D15:D27,MATCH(1,IF(B15:B27=B1,IF(C15:C27=B4,1)),0))
Using the data in B13:G27

In cell C3 I have a list and can use the drop down and D3 will automatically change the data in D3.

That’s what I want for cell D4 too, but I have both cell B4 and B5 that I want to use as drop downs.

Does anybody have any ideas? Just an fyi I have downsized my data to simply things.

Thanks

I can't believe I did that. Not B5. It's cells B4 and C4.

I've been working on it and I'm getting closer, but haven't got it yet.

Basically I want to look at the data B13:G27. I want to choose the name in cell B1, choose the Indicator in cell B4 and then select what I want for cell C4.

So it makes sense to me that first I want to search for the name, then the indicator and then one of the titles.

Sorry for the typo and I really appreciate the help!

Try this:
D3: =INDEX(C8:G11;MATCH(B3;B8:B11;0);MATCH(C3;C6:G6;0))
D4: {=INDEX(D15:G27;MATCH(1;(B3=B15:B27)*(B4=C15:C27);0);MATCH(C4;D13:G13;0))}
I moved the name to B3
//Ola

That's awesome!!!! Thank you so much! I really appreciate it!

Happy it was what you wanted.
Thanks for the feedback.
//Ola