| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option.
I have this formula: =IF(ISERROR(INDEX('8DBC'!$A$1:$BG$500,MATCH($A10,' 8DBC'!$A$1:$A$500,0),49)),"",INDEX('8DBC'!$A$1:$BG $500,MATCH($A10,'8DBC'!$A$1:$A$500,0),49)) I need to be able to see if there is data in the range matching up in 8DBC, column 49, if not, to draw information from SI-1, column 4. How do I format this formula to do just that? I have tried, but I struggle with formula error's :) Regards -- sonar ------------------------------------------------------------------------ sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424 View this thread: http://www.excelforum.com/showthread...hreadid=466880 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Button Help | Excel Worksheet Functions | |||
| the option "sent to" mail recipient is not available in excel 200 | Excel Discussion (Misc queries) | |||
| Second option button disappears when I make another column | Excel Worksheet Functions | |||
| Filter option | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
