View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Annette Annette is offline
external usenet poster
 
Posts: 4
Default match two items to table for result

I'm not getting my formula. I have product names in column G and service
types across the first row (H:J)

My formula is to match a2 to find the correct cell in column g then match a4
to find the correct service type and where the two intersect, display
result.

a2
round

a4
green


g) h) i)
j)
red white
green
square 1 5
8
oval 7 3
2
round 6 4
9

The result should be 9.

Thank you for any help you can provide.