formula help

[uul]

Hi all,

Got this formula

=IF(INDEX([source]Feeder!$E$2:$E$5003,ROWS($A$1:A49))=0,"",INDEX([source]Feeder!$E$2:$E$5003,ROWS($A$1:A49)))

Basically it is looking at a table of data that is returning N/A - how do i adapt this formula to ignore N/A and return a blank cell, until a value is returned.

Thanks

 

[Bhawani]

use below function :

=iferror(IF(INDEX([source]Feeder!$E$2:$E$5003,ROWS($A$1:A49))=0,"",INDEX([source]Feeder!$E$2:$E$5003,ROWS($A$1:A49))),"")

hope it will fulfill your requirement

 

[uul]

Perfect thx Bhawani