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

=IF(AND($A$1="gopal minerals",'Gopal Sales'!E60),'Gopal Sales'!E6,
IF(AND($A$1="Micro Products",'Micro Sales'!E60),'Micro Sales'!E6,
IF(AND($A$1="Ultra Fine Filler Private Limited",'Ultra Sales'!E60),'Ultra
Sales'!E6,"")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rao Ratan Singh" wrote in message
...
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

Thank you sir,
It is working. thanks and regards

yours

RRS

My pleasure sir!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rao Ratan Singh" wrote in message
...
Thank you sir,
It is working. thanks and regards

yours

RRS