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