Lookup From Cell Range By Matching Row and Column

[paul_pearson]

Hello All,

I have attached a sheet where i need formulas or maybe a Lookup function to achieve result.

1. I enter a solid number from Row 9 into J3 (merged cell)
2. I enter a FILL numbers from Column B into J4 (merged cell)
3. The result should then show 91 in cell J4 (merged cell)...which formula or Lookup function do i use?

Thanks

Paultable.xlsx

[Excel Fox]

Try this... =INDEX($F$12:$AP$35,MATCH(J4,$B$12:$B$35,0),MATCH( J3,$F$9:$AP$9,0))

[paul_pearson]

Thank you Excel Fox
Appreciated