if no value go to next cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Without using VBA, there is no way to do what you want if your condition
isn't met.

HTH,
Barb Reinhardt
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Scrabble Value calculation for Welsh words 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
lookup functions and text comparisons 1
Vlookup and return sheet name also 2
If function across sheets prints value of cell 4
Nested If with Lookup 1
VLOOKUP source values are a formula result. Getting #N/A 7

Back
Top