Thread: Lookup?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.