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