Referencing a cell [that updates with the date] to a sheet from another workbook that...
Referencing a cell [that updates with the date] to a sheet from another workbook [that has that particular date] and then referencing a column. So when it goes to a new sheet in the worksheet, it will reference a column and a cell within the column...
So I was doing VLOOKUP and INDIRECT, but I dont want to manually do anything (if that makes sense).
=VLOOKUP(D2,'[PC-SCHEDULE.xlsm]Jul19'!$AC$9:$BD$39,28,FALSE)
^---I just want this to update(the Jul19' (thats from the separate workbook)).
Try
=VLOOKUP(D2,INDIRECT("'[PC-SCHEDULE.xlsm]"&A1&"!$AC$9:$BD$39"),28,FALSE)
You'll need to replace A1 with the workbook/sheet/cellreference that you're referring to.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I just tried that, but it is giving a #REF error. Not sure if its a single quote or quotations we're missing.
So, specifically what formula did you type in?
Did you copy and paste or type? If you typed, make sure the quotes are STRAIGHT quotes, not angled or curly ones.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I had a quote missing just before the exclamation mark and $AC$9
=VLOOKUP(D2,INDIRECT("'[PC-SCHEDULE.xlsm]"&A1&"'!$AC$9:$BD$39"),28,FALSE)
Last edited by Special-K; 08-01-2019 at 05:38 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks