Is there a way to insert a variable into a VLookup string? For instance, I have the following formula in a cell:
I would like to be able to substitute the 020105.xls with a cell reference. I would like the formula to look at cell b6, for instance, to get the document name. Is that possible?
What I am trying to do is to reference existing daily inventory worksheets and be able to put the beginning inventory date in one column and the ending inventory date in the next column to get the difference in inventory between the 2 days. The daily worksheets are named consistently with the date as their name. Any better ideas to accomplish this task?
Thanks in advance for your assistance! Linda