#value! errors on vlookups

[chriswhincup]

Hi, I'm pulling information in from some pivot tables into another sheet so i can work cleaner with the data (they use slicers and I need to be able to graph them) but when I try to divide one column by another i'm getting a #value! error. Its only happening when there is no data in the fields for months in the future. This occurs whether I do a straight M18/J18 calc or whether I try to source the data using the below.

=M18/VLOOKUP(J18,$F$10:$H$21,3,FALSE)

It works fine when there is data in the cells and only happens on future months. All the cells I'm pulling from have vlookup formulas already in them that either lookup the data from my pivot table or return blank fields.

 

[Peter_SSs]

So, what do you want to happen when this error occurs?
Is it this?

=IFERROR(M18/VLOOKUP(J18,$F$10:$H$21,3,FALSE),"")

 

[chriswhincup]

So, what do you want to happen when this error occurs?
Is it this?

=IFERROR(M18/VLOOKUP(J18,$F$10:$H$21,3,FALSE),"")

Exactly this thank you. Just couldnt get the syntax to work.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.