Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for data and return cell reference
I would like a forumla that searches my spreadsheet for a word, e.g. "july"
and returns the reference of the cell that it is in, so I can use it for the rest of a lookup formula. Any help would be most appreciated, Rob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for data and return cell reference
Try this UDF:
Public Function julyy(inRng As Range) As String Set r = Application.Caller ad = r.Address julyy = "" For Each rr In inRng If Not Intersect(rr, r) Is Nothing Then Else If rr.Value = "july" Then julyy = rr.Address Exit Function End If End If Next End Function -- Gary''s Student - gsnu200796 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for data and return cell reference
See Help information for the function =Match()
Returns the relative position of an item in an array that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself. HTH John "exoticdisease" wrote in message ... I would like a forumla that searches my spreadsheet for a word, e.g. "july" and returns the reference of the cell that it is in, so I can use it for the rest of a lookup formula. Any help would be most appreciated, Rob |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for data and return cell reference
A UDF perhaps
this goes in a general module Public Function FindMe(SrchFor As String, Rng As Range) As String Set x = Application.Caller For Each c In Rng If Not Intersect(c, x) Is Nothing Then Else If c.Value = SrchFor Then FindMe = c.Address Exit Function End If End If Next End Function call with =findme(a1,a2:d100) Were A1 is what you are looking for Mike "exoticdisease" wrote: I would like a forumla that searches my spreadsheet for a word, e.g. "july" and returns the reference of the cell that it is in, so I can use it for the rest of a lookup formula. Any help would be most appreciated, Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for data and return multiple fields | Excel Discussion (Misc queries) | |||
Search a Row and return Header Row Data | Excel Discussion (Misc queries) | |||
Search Column Data and Return Multiple Values across Row | Excel Worksheet Functions | |||
Search for a number in a table and return data of a specific cell | Excel Discussion (Misc queries) | |||
search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) |