Without using VBA, there is no way to do what you want if your condition
isn't met.

HTH,
Barb Reinhardt

"Robee31" wrote:

I am currently trying to lookup a value from another work sheet
I have the formula =IF('[Container Receiving.xls]Container
Detail'!$E$20,'[Container Receiving.xls]Container Detail'!$A$2,"")
I just want the list to return values instead of blanks.

Thanks
Robee31