I have what I thought was a simple, straightforward application of VLOOKUP; however, when I programmed it, it didn't work. In an attempt to diagnose the problem, I shortened the table by just deleting one of the number '8's from the table length (so, the end of the table is on row 8, instead of row 88) - and then VLOOKUP worked properly for my shortened length.
Would someone please tell me what I'm missing and how to fix this VLOOKUP to function properly for the entire column?
Bookmarks