| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function to find value and return cell reference
Hi,
I'm looking for a function that will find a value somewhere on a spreadsheet and return its cell reference. For instance, I'd like to be able to have a function that will take '300' and the data range 'A1:D5' and then return the cell that '300' is found in, i.e. D3 (if indeed D3 contains '300'). Do I need to write a macro for this? Thanks, rcc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| 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 Cell Reference Resulting from MAX function | Excel Worksheet Functions | |||
| return the column reference number of a function result | Excel Discussion (Misc queries) | |||
Threaded Mode
