I am using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I am collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data.
Bookmarks