Lookup?
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.
|