Forum Discussion
jdkuehne
Oct 04, 2022Copper Contributor
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...
- Oct 04, 2022That absolutely is the correct answer. I was being led astray by different tutorials not explaining things clearly. Thank you so much!
mathetes
Oct 04, 2022Silver Contributor
You don't mention exactly what column or cell this VLOOKUP formula is in. And where that is in relation to the cell containing the dropdown selection that is to be used as the first reference in the VLOOKUP. Those are two key elements.
- Assuming for sake of illustration that the drop down is in cell C2 of the "Form" tab, I think your VLOOKUP should read simply
- =VLOOKUP(C2,Data,2,FALSE)
- The drop down may itself refer to the list of "Items" but the VLOOKUP should refer to the actual item that was selected.
That's my suggestion based on what I've gleaned from what you've written. If that doesn't make sense, or doesn't work, might I suggest you post a copy of the spreadsheet on OneDrive or GoogleDrive, followed by posting a link here granting access to look at your workbook.
jdkuehne
Oct 04, 2022Copper Contributor
That absolutely is the correct answer. I was being led astray by different tutorials not explaining things clearly. Thank you so much!