Jul 28 2022 03:13 AM
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.
Jul 28 2022 03:26 AM
Below formula should work for you.
=INDEX(B36:F50000,MATCH(I3,A36:A50000,0),MATCH(H3,B35:F35,0))
Jul 28 2022 03:29 AM
SolutionJul 28 2022 03:29 AM
Solution