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?
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?
Your reply only became visible today...
Replace 'Dummy2025 Rally Workbook V-3.xlsx'!Table_2 with the name of the table in your active prototype.
I added data validation to the NAME column: