Hello all,
Sorry if this makes no sense.
What I want to do is look upward relative to a cell to find the cell containing a site number then return the cell reference so then I can extract the site number from the text and populate another cell.
So for cell A:10 to A:12 I would like to return the cell ref of A:8 and cells A:16 to A:20 I would like to return the cell ref A:14 and so on.
Any help would be appreciated.
Thanks in advance.
Bas.
Use this in A10 and copy paste to all other cells.
Formula:
Please Login or Register to view this content.
Try this...
Entered in G10 and copied down:
=IF(ISNUMBER(B10),ADDRESS(LOOKUP(2,1/(A$1:A10=""),ROW(A$1:A10))+1,1,4),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks Guys. Both methods worked. Zbor's method returned the text and Tony's returned the cell reference. Thanks again!
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks