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