L
Lance
=ADDRESS(MATCH(3,E9:E13,0)+ROW(E9)-1,MATCH("C",E9:I9,0)
+COLUMN(E9)-1)
Will return the address $H$12 for column match (c) and
offset 3
CELL
-E9- a b c d
1 1 2 3 4
2 5 6 7 8
3 9 10 11 12
4 13 14 15 16
I don't know if this helps
Lance
+COLUMN(E9)-1)
Will return the address $H$12 for column match (c) and
offset 3
CELL
-E9- a b c d
1 1 2 3 4
2 5 6 7 8
3 9 10 11 12
4 13 14 15 16
I don't know if this helps
Lance