Hi

try
=ADDRESS(1,MATCH(A2,A1:F1,0))
where 1 is the row number of your list of values (ie the range A1:F1) and A2
is the value to match to.


Cheers
JulieD

"freds" wrote in message
...
Hi, I'm wondering whether anyone can help me with a formula in Excel which
I'm having trouble with.

eg:
Row 1. Col A value = 10, B = 12, C = 14, D = 16, E = 18, F = 20

Row 2. Col A value = 14

The values in Rows 1 and 2 are dynamic and may change based on other
formulas elsewhere in the Worksheet.

But Row 2 will always have a value that equals a value in Row 1.

Result Required:
I would like to find the CELL reference from Row 1 for the number that
matches that in Row 2. The Result in this case = $C$1. However the formula
must work everytime based on the fact that values can change in all
fields.

I know how to find the Cell that matches 14 separately, and I know how to
get a Cell Address separately. However I can't manage to get a combined
formula that will always give me the correct cell reference for the
numbers
that match.