| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Or is this what you're looking for... =IF(ISNUMBER(A1)*ISNUMBER(B1),IF((LOOKUP(2,1/A1:A10,A1:A10))*(INDEX(B:B,LOOKUP(2,1/A1:A10,ROW(A1:A10)))=""),LOOKUP(9.99999999999999E+ 307,C:C),0),"") or, maybe this one... =IF(ISNUMBER(A1)*ISNUMBER(B1),IF((LOOKUP(2,1/A1:A10,A1:A10))*(INDEX(B:B,LOOKUP(2,1/A1:A10,ROW(A1:A10)))=""),INDEX(C:C,LOOKUP(2,1/A1:A10,ROW(A1:A10))),0),"") -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=278034 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
| View and Cell Sum Range | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
| How to populate column with formula based on value in cell | Excel Worksheet Functions | |||
Hybrid Mode
