Member Since: Aug 17th 2018
Aug 17th 2018
Wow, thank you David. This has been the first insight into what has been going on with my VLOOKUP I've found in the many hours spent looking online for an answer. It helps a lot. I've even registered with accountingweb.com so that I can talk to you, even though I'm not in accounting. However, now that I've discovered the problem, I can't apply it to my own scenario. In my look-up table, the first column has to be a formula and not just a list of numbers I type in manually so that your solution works. (Your solution DOES work in the test I ran, but I had to forego the formula in that cell to get it). Is there a work-around I can check for, so I can keep my formulas in the first column of my table?