Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Worksheets
Hi all,
I'm looking to modify my search of other worksheets. At the moment I am currently using this formula which tells me the number of times that A6 is in the "Second Worksheet" in Column K. =SUMPRODUCT(--ISNUMBER(SEARCH(A6,'Second Worksheet'!$K$3:$K$279))) Now i want to modify it to instead of returning the number of times that A6 is in Column K in the Second Worksheet, i want it to return the cell references that it occurs in. So instead of returning 3 it will return K70 K120 K200. I would even be happy if it just returned the row where it was located. Is this possible if so what functions should i be looking at? Cheers, Paddy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching Across Worksheets: Please help! | New Users to Excel | |||
vba searching for strings in multiple worksheets | Excel Discussion (Misc queries) | |||
Define list of worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
Merge Worksheets | Excel Worksheet Functions |