Share via

Can Vlookup point to another sheet?

Anonymous
2021-09-08T18:17:27+00:00

Hello. Is there a way to write a vlookup formula that is similar to this =vlookup(A1,A5:G14,7,False). But instead of the A5:G14 range to select a range on another sheet> And instead of column 7 for the lookup value to have it point to a column on another sheet?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2021-09-08T18:44:51+00:00

    Sure, try the procedure shown below.

    Andreas.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-09-08T22:23:46+00:00

    Hi,

    Not only another sheet but also another Excel file:

    =VLOOKUP(Sheet2!A5,'Chapter 01 - Introduction.xlsm'!Table1[#Data],4,0)

    Sheet2!A5 is in the current file, but Table1 is in another file: Chapter 01 - Introduction.xlsm.

    Shane

    0 comments
  3. Anonymous
    2021-09-08T20:17:01+00:00

    Thank you - perfectly clear.

    0 comments