Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey
The following formula returns a numeric(percent) value: =MIN(IF((LEFT('PDAs Report'!G3:G1000,3)="BJ ")*('PDAs Report'! H3:H1000=L9),'PDAs Report'!J3:J1000)) In order for the numeric values to even be evaluated, the following 2 conditions must be met: The value in range G3:G1000 must contain "BJ ". The numeric value in range H3:H1000 MUST be greater than the numeric value in cell L9. The formula then returns the minimum value from all the values that met the above criteria. My question is how can I make it return the actual cell address instead of the value of the cell? Can you please provide me a few methods to reach the desired result? Thanks Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
V Lookup and return cell address | Excel Worksheet Functions | |||
How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions |