Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for Cell address | Excel Worksheet Functions | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
Cell Address in Formula | Excel Discussion (Misc queries) | |||
Display a cell address | Excel Worksheet Functions | |||
Display the address of cell with max value | Excel Worksheet Functions |