One way ..
In say, A5:
=OFFSET(G2,MATCH(A2,G3:G5,0),MATCH(A4,H2:J2,0))
Adapt the ranges: G3:G5, H2:J2
to suit the actual extents of your table
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Annette" wrote:
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.