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 |
#2
|
|||
|
|||
What's your criteria when selecting a proper value from sheet SI-1? You need a function to select a value from sheet SI-1 when ISERROR() is true. sonar Wrote: 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 -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=466880 |
#3
|
|||
|
|||
Hi, Not to worry, I managed to circumvent the problem by placing the query somewhere else, and let the sheet do a normal extraction. Thanks Regards Sonar -- sonar ------------------------------------------------------------------------ sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424 View this thread: http://www.excelforum.com/showthread...hreadid=466880 |
#4
|
|||
|
|||
Hi!
In your formula your are testing for an error in a range and if there is one to return blank. If there is no error, then return the data from that same range. However, your description is saying if there is an error in one range then return data from a completely different range, SI-1, column 4. You don't need to include the INDEX call inside of ISERROR. You can shorten your current formula to: =IF(ISNA(MATCH($A10,'8DBC'!$A$1:$A$500,0)),"",INDE X('8DBC'!$A$1:$BG$500,MATCH($A10,'8DBC'!$A$1:$A$50 0,0),49)) Biff "sonar" wrote in message ... 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 |
Reply |
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 |