Lookup value in row and column based on cell criteria

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.


.

Relevant Pages

  • match two items to table for result
    ... types across the first row ... to find the correct service type and where the two intersect, display ...
    (microsoft.public.excel.worksheet.functions)
  • Re: match two items to table for result
    ... types across the first row ... My formula is to match a2 to find the correct cell in column g then match ... to find the correct service type and where the two intersect, display ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Lookup value in row and column based on cell criteria
    ... Are you trying to create a SQL table to do the lookup? ... already exist within the SMS database? ... types across the first row ... a4 to find the correct service type and where the two intersect, ...
    (microsoft.public.sms.admin)