View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
 
Posts: 191
Default formula to display cell address

I need a formula to display a cell address

I want C1 to compare B1 to A1:A14 and bring back the cell reference if there
is a match.
In the below example C1 should read A2.
Thanks in advance for any help.

A B C
1 5 10
2 10 20
3 15 30
4 20 40
5 25 50
6 30 60
7 35 70
8 40 80
9 45 90
10 50 100
11 55 110
12 60 120
13 65 130
14 70 140