if no value go to next cell
 

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

if no value go to next cell
 

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