| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to display cell reference (ex.. B7)
I built a formula but I need it to display the cell reference (column letter
& row number), not TRUE or FALSE, of the cell(s) that matches the criterias. I have provided the formula to demonstrate what I'm trying to do. =IF(--($F17="B")--($F17="D")--($F17="RS")*AND($M17="no",$O17="no"),"cell reference") The cell reference should indicate the cell in column "$F" along with the row number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Copy formula down a column does not use correct cell reference | Excel Discussion (Misc queries) | |||
| Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
