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