Forum Discussion
Solved
VLOOKUP Errors
I'm working in Excel 2016 and VLOOKUP is kicking my butt! My workbook has two sheets, "Form" and "Table". On "Form", I've created a form with a drop-down list from a named range ("Range") on a ta...
- That absolutely is the correct answer. I was being led astray by different tutorials not explaining things clearly. Thank you so much!
The structured references seem to be the issue. I recommend building the VLOOKUP by selecting your lookup_value and table array by hand. Excel will put in the table references for you where needed.