Re: Lookup value in row and column based on cell criteria

Are you trying to create a SQL table to do the lookup? Does this data
already exist within the SMS database?


"Annette" <shedge@xxxxxxx> wrote in message
news:emr8VAROHHA.5064@xxxxxxxxxxxxxxxxxxxxxxx
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