Help with N/A in formulas

[Mark D]

Afternoon everyone

I have 2 formulas that I need a little bit of help on. Both are working fine
but I want the cell to be blank if the result is N/A. Just not sure how I add
it in,

1st Formula
=VLOOKUP(A2,'NEW Sales booked Jan-Mar'!$1:$65536,1,FALSE)

2nd Formula
=NETWORKDAYS(H2,U2)

But I need the 2nd formula seems a little trickier

H2 will always have a date in it. But U2 wont if the VLOOKUP returns a BLANK
result
So I need the 2nd formula to read if U2 doesn't have a date in it put blank,
otherwise run the formula.

Thanks in advance for your help

 

[JP Ronse]

Hi Mark,

In Excel 2003 use

= IF(ISNA(VLOOKUP(A2,'NEW Sales booked
Jan-Mar'!$1:$65536,1,FALSE)),"",VLOOKUP(A2,'NEW Sales booked
Jan-Mar'!$1:$65536,1,FALSE))

In Excel 2007

= IFERROR(VLOOKUP(A2,'NEW Sales booked Jan-Mar'!$1:$65536,1,FALSE),"")

Similar for the 2nd formula.

Hope this helps.

With kind regards,

JP

 

[Mark D]

Excellent, thank you

Hi Mark,

In Excel 2003 use

= IF(ISNA(VLOOKUP(A2,'NEW Sales booked
Jan-Mar'!$1:$65536,1,FALSE)),"",VLOOKUP(A2,'NEW Sales booked
Jan-Mar'!$1:$65536,1,FALSE))

In Excel 2007

= IFERROR(VLOOKUP(A2,'NEW Sales booked Jan-Mar'!$1:$65536,1,FALSE),"")

Similar for the 2nd formula.

Hope this helps.

With kind regards,

JP





.

 

[JP Ronse]

You are welcome, thanks for the feedback.

Excellent, thank you