if no value go to next cell

R

Robee31

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

Thanks
Robee31
 
B

Barb Reinhardt

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

HTH,
Barb Reinhardt
 
Top