spittingfire
10-19-2016, 04:29 AM
HI All,
I've attached an excel sheet with some sample data. In "Sheet1" in column J I've constructed a vlookup / indirect combo formula that is working for me on and off. I just need to get something stable that will work all the time no matter how many times the file is opened and closed.
What I'm trying to do is to lookup the time in cell N1 then match the name from column B to the sheet name then return the values from column AE of the matched sheet where the time matches AB on the matched sheet.
Initially the formula worked but then doesn't work anymore and I'm a bit lost.
Any help would be much appreciated.
Thanks17370
I've attached an excel sheet with some sample data. In "Sheet1" in column J I've constructed a vlookup / indirect combo formula that is working for me on and off. I just need to get something stable that will work all the time no matter how many times the file is opened and closed.
What I'm trying to do is to lookup the time in cell N1 then match the name from column B to the sheet name then return the values from column AE of the matched sheet where the time matches AB on the matched sheet.
Initially the formula worked but then doesn't work anymore and I'm a bit lost.
Any help would be much appreciated.
Thanks17370