Forum Discussion

kwahl1's avatar
kwahl1
Copper Contributor
Mar 14, 2025
Solved

Using VLOOKUP over multiple columns

Pardon me if I posted this earlier.  I didn't see my questions when I later returned so here it goes again.  Using Microsoft 365 personal, Excel on a MacBook. I have a basis understanding what VLOOKU...
excel
Excel on Mac
  • HansVogelaar's avatar
    HansVogelaar
    Mar 14, 2025

    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?

HansVogelaar's avatar
HansVogelaar
MVP
Mar 14, 2025

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?

Resources