Share via

use Vlookup in Excel Online

Anonymous
2022-04-28T07:27:33+00:00

Hi All,

I was trying to use vlookup function between 2 sheets, But as we have only E1 licenses we can only use excel online.

Can anyone please help me using Vlookp/Xlookup or any function in Excel Online where i have to use multiple sheets.

Regards

Abhishek

Microsoft 365 and Office | Excel | For business | 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

Answer accepted by question author

  1. Anonymous
    2022-04-28T13:01:51+00:00

    Dear Anhishek,

    Thanks for your updates. I'm afraid that the VLOOKUP formula may not work in two different workbooks in Excel for the web. As a workaround, you may use Power Automate to grab the data from an external file and update the external data in your file where you use the VLOOKUP formula. Then you can update the formula values from the external file.For example, you update the VLOOKUP formula values in Sheet1 in Book1. The reference data is in Sheet1 in Book2. You can use Power Automate to grab the updated data from Sheet1 in Book2 and update the data in Sheet2 in Book1 and then the VLOOKUP formula grabs the data from Sheet2 in Book1. This will complete making the formula update the data from Sheet1 in Book2 automatically. You can set the flow to be ran in a specific period.![](https://learn-attachment.microsoft.com/api/attachments/7b80d929-94fc-4de3-bb3e-b94882608310?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/283cd200-18fa-4b21-8679-10c5b9f1aff7?platform=QnA" rel="ugc nofollow">![](https://learn-attachment.microsoft.com/api/attachments/283cd200-18fa-4b21-8679-10c5b9f1aff7?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/12d82e3e-8cc1-46f9-87a0-d3dc2515a9e2?platform=QnA" rel="ugc nofollow">![](https://learn-attachment.microsoft.com/api/attachments/12d82e3e-8cc1-46f9-87a0-d3dc2515a9e2?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/70b68021-3cbe-403b-a077-28eb9a45eb53?platform=QnA" rel="ugc nofollow">![](https://learn-attachment.microsoft.com/api/attachments/70b68021-3cbe-403b-a077-28eb9a45eb53?platform=QnA

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-28T09:17:02+00:00

    Hi Cliff,

    I am sorry.. May be I put it in wrong way..

    I am trying to use 2 different worksheets.(2 different excel Files), I can use vlookup in a single workbook with different sheets.

    But not sure how it works if there are different files.

    Thanks in Advance...

    0 comments
  2. Anonymous
    2022-04-28T09:01:52+00:00

    Dear Anhishek,

    The VLOOKUP formula should work in Excel for the web in two sheets.

    Here is an example for your reference.

    Welcome to share any updates at your convenience if you need further help on this issue.

    Best Regards,

    Cliff

    0 comments