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.