| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find data in Range, Return Cell Reference
I want to see if a value in A1 is present in an array, say B1:D15, and then
return the refernce of the cell in which the value is held. The value in A1 will not occur more than once in the array. For instance, if the value in A1=30, and 30 appears in cell D4, I want to return D4 (or $D$4). Is there a formula or function that will return the cell reference of cell containing a specific value? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to find value and return cell reference | Excel Discussion (Misc queries) | |||
| locate a cell value within a range and return its reference | Excel Discussion (Misc queries) | |||
| Find a value in a table and return the cell or column reference | Excel Discussion (Misc queries) | |||
| Find a value in a table and return the cell reference | Excel Worksheet Functions | |||
| find the first blank cell in a range and return me it's position | Links and Linking in Excel | |||
Threaded Mode
