Forum Discussion
Using VLOOKUP over multiple columns
Perhaps you simply need to expand the lookup range.
For example, if your formula now looks like this:
=VLOOKUP(A2, 'Roster Sheet'!$A$2:$G$1000, 16, FALSE)
change that to
=VLOOKUP(A2, 'Roster Sheet'!$A$2:$Z$1000, 16, FALSE)
You'll have to modify this for your setup.
If this doesn't help:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
See the attached version. I edited the formulas to use structured table references.
Great job! Let me run it by the Registrar who will b receiving information and inputing the various fields. I'm just assisting.
If we decide to add a column, say in the tan area, like "Guest", will the formula need to be updated in Q and R =IFERROR(VLOOKUP(B3,Table_2,7,FALSE)&"", "") and =IFERROR(VLOOKUP(B3,Table_2,8,FALSE)&"", "") because of inserting columns? Also noticed you used Table_2 in the formula, not the tab name. I guess it works OK that way.
Ken
I only now got notified of your reply.
> will the formula need to be updated?
No, probably not.
Thank you, not to worry. My end user, Registrar, has suggested a few more columns be added so I will work on that.
I ran into a problem Friday when I tried to copy the tab into my active prototype I'm developing. When I went to paste into my workbook, my addresses are referring back to the Dummy Workbook
=IFERROR(VLOOKUP([@NAME],'Dummy2025 Rally Workbook V-3.xlsx'!Table_2[#Data],2,FALSE)&"", "")
Please update this line in the address column.
I need this to VLOOKUP on my Info fill tab on the current workbook.
Also when I brought in 2025 Registration I don't have the drop down menus I had earlier. I think its Data validation, I need the drop down menus. Or is it tables?
