Vlookup based on two cells to populate from multiple sheets?

Hi there. To make this work (using my suggestion), you need to changet eh format of your sheet names, as shown. You then neeed to use a combination of indirect and a text function to make the date match the sheetname (the Tab won't accept a / ).

Try it out...

See attached for a slightly different method in which you wouldn't have to change your sheet name format.

Hope this helps!

That's a nice alternative approach. However, i went "My Way" so that the date in the tracker sheet is actually a date, and not a number that looks like a date, s that other manipulations could bne made using the date field.

Yup, still gets the job done. Just an alternate form; good work!

One enhancement, with a nod to mcmahobt. He was right to choose an INDEX-MATCH, rather than a VLOOKUP (more robust). So, I've combined his formula and mine to give you a better solution. Enjoy...