Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to find text on a page and return that cells name.
I have several pages each with cells having unique cell names. In each of
those cells is text names. I need to have a formula on a summary page that will find the specified name say "bill", and return the cell name of each cell on the other pages that say "bill". I cant use Hlookup or Vlookup because the names could be in several places on the pages so I cant limit the search to a specific table. Is this even possible? I can have a macro do it but would prefer a formula. Thanks, Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find text from 1 col in 2nd col & return value from 3rd col | Excel Worksheet Functions | |||
Find max value from 3 cells, return text, but 2 max values same! | New Users to Excel | |||
Find value between range & return text | Excel Worksheet Functions | |||
Find text and return - NOOB question | Excel Discussion (Misc queries) | |||
Find certain text in a column and return statement | Excel Worksheet Functions |