LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Cell address Elton Law[_2_] Excel Worksheet Functions 3 April 8th 09 05:23 PM
find last cell in range with data, display cell address sevi61 Excel Worksheet Functions 14 October 29th 07 08:36 PM
Cell Address in Formula Laury Excel Discussion (Misc queries) 2 October 8th 07 06:23 PM
Display a cell address sam Excel Worksheet Functions 2 September 25th 07 05:20 PM
Display the address of cell with max value Liz C Excel Worksheet Functions 7 January 28th 05 11:11 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"