Share via

Dynamically link to different workbook

Anonymous
2022-02-28T07:42:36+00:00

Hi everyone, hoping you're having a great day!

I am working on a workbook (let's call it A) that utilises INDEX and MATCH to lookup values from different database workbook. I want it to know which workbook to look, say if I put in cell A1 the name of the DB workbook it should do indexing and matching in that DB workbook.

I don't want to have to put the DB inside the same workbook since it's 10,000 rows of data.\

Also I'm planning to embed that workbook A onto a website, would that still work interactively? Say if someone type in that DB keyword, would the embedded workbook still work as expected?

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-28T10:11:39+00:00

    Hi, I'm Elise, and I'd be happy to help with your issue.

    You can use the INDIRECT function to reference another workbook based on a cell value, however linking to another workbook is not going to work if you need to embed it onto a website, it can only reference data from the same sheet, or static values from another sheet at the point it was embedded.

    Please let me know if you need any further assistance.

    Kind Regards,

    Elise

    Was this answer helpful?

    0 comments