Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help! Formula to find the address of particular value in sheet
Hi All, Iam a excel newbie.I want to know is there any formula avaliable to find the address of particular value in sheet.For eg if there is value "Mark" in some cells in sheet i want to find the address of that cell.Is it possible through formula or do i have to write UDF ? Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=386737 |
#2
|
|||
|
|||
To find the address, you need to know which cell the value "mark" is in. If you know that (and assuming it is C4), then use: =CELL("address",C4) If you use some formula then use: =ADDRESS(MATCH("mark",C:C),3) here, we know before hand that "mark" lies in column C and so use 3, and match "mark" in column C to get the row number. You could reverse it for unknown column position, and a known row. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=386737 |
#3
|
|||
|
|||
Hi Mangesh Thanks for your help.I really solved my issue and save me a lot of time :) Thanks Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=386737 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find cell with data on a row | Excel Worksheet Functions | |||
Find and Replace Formula Links | Excel Worksheet Functions | |||
The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel |