I am using the following vlookup function in a very large Excel spreadsheet:
=VLOOKUP($B1744,INDIRECT($D$2&"Dealer2'!$A$5:$BF$498"),$H$2,0)
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.
Bookmarks