On Nov 11, 4:10*pm, Pete_UK wrote:
I'm glad to hear that, so thanks for feeding back.

Actually, I was in a rush because I had to go out, and I now notice
that I missed off the reference to SheetB in the second MATCH
function. Presumably you picked this up, but just for the sake of
completeness the formula should be:

=INDEX(SheetB!$B$9:$BU$80,MATCH(P20,SheetB!$A$9:$A
$80),MATCH(J20,SheetB!$B$8:$BU$8))

Hope this helps.

Pete

On Nov 11, 7:39*pm, clk wrote:





It worked!!! *Thank you so much for your assistance. *That is exactly
what I needed.- Hide quoted text -

- Show quoted text -

Yes I did catch that and fixed it on my formula. :) Thanks again for
the assistance.