I am using the following vlookup function in a very large Excel spreadsheet:
Please note Dealer2 within the function. If I use Dealer1 or Dealer3, for example, the correct answer appears. This same function is used for Dealer1 through Dealer20.
Using the function as shown above with Dealer2, it returns a #REF! error.
I think this is because, at this time, there is not a Dealer2.
Is it possible to have it return something such as 0 or - if there is currently not a Dealer2, so the totals will be correct.