SOLVED

Help with vlookup / index or other

Occasional Contributor

Hi, I have dropdown boxes on the chart below in H3 & I3. What im trying to do is post the number in the chart in the 2nd image to cell N3 depending on what is selected in H3 & I3, Is this possible?

 

Any help will be appreciated.

 

Screenshot 2022-07-28 102418.pngScreenshot 2022-07-28 102537.png

  

2 Replies

@mikec5000 

Below formula should work for you.

=INDEX(B36:F50000,MATCH(I3,A36:A50000,0),MATCH(H3,B35:F35,0))
best response confirmed by mikec5000 (Occasional Contributor)
Solution
Perfect! Thank you so much! Worked perfectly