vlookup with indirect function |

2023年3月22日 — hi, I'm trying to indirect to another workbook ... To update information from closed workbooks ... workbook where I am doing the vlookup() from are ...

2023年4月6日 — The INDIRECT formulas work absolutely fine when the workbooks are open, however I need them to work when the other files are closed. The ...

Referencing a closed workbook with INDIRECT. In the following example, an INDIRECT function is attempting to reference a workbook that's closed, causing a #REF!

2021年10月15日 — I am trying to maintain a data rundown file to compile the ETA dates from the shipment schedule files. Right now I am using Indirect function ...

2018年8月3日 — If I understand the root of your question, the INDIRECT function does not read from a closed workbook, which is why your VLOOKUP function ...

2015年2月11日 — In Excel 2016 at least, you can use INDIRECT with a full path reference; the entire reference (including sheet name) needs to be enclosed by ' ...

2017年11月7日 — INDIRECT will work ONLY if both sheets are open. If you're OK with a little VBA, it can be done. If that's OK, please post 2 sample workbooks.

2021年9月13日 — I am using VLOOKUP and INDIRECT to look up specific values in a separate workbook. I have created the following formula and it does return the ...

2021年11月22日 — Indirect works only when other file is open, i'd like to leave it closed. Upvote