How can i get a IF formula to skip to the next reference box

  • Thread starter Craig Turley - Emerson
  • Start date
C

Craig Turley - Emerson

I have a "IF" formula which looks up a cell on another worksheet, if the cell
has a value it returns another cell's value with in that work sheet, to the
previous cell with "IF" function in. The cells in the colum in wich i
reference from will change from no data to 1 or etc.

I want to drag the information down the work book but avoid the the null
value wich will appear like so.

code desc qty price
KATUR cat flap 1 £300
KATURB black cat flap 2 £900

not what im getting now

code desc qty price
KATUR cat flap 1 £300
-------- ----------- - -----
KATURB black cat flap 2 £900
 

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

using an IF or AND function to get next largest value in list 1
SUM FORMULA- skipping every seventh row 1
Using an offset formula for the reference in a relative reference 6
Looking for the correct excel formula 2
Cell reference in formula string displays abbreviated value 2
How do I combine/join multiple formulas 2
Can I Skip a row in my formula? 3
How do I ref. a cell range and populate adjacent cells? 2

Top