Dear Sir,
I m using this function =IF(AND($A$1="gopal minerals",'Gopal
Sales'!E60),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro
Sales'!E60,'Micro Sales'!E6,$A$1="Ultra Fine Filler Private Limited", 'Ultra
Sales'!E60, 'Ultra Sales'!E6,""))

but when it found empty cells in respective sheet it returns #value!. I want
it should return blank.

How it can be. solve my problem please.

RRS