INDIRECT VLOOKUP with date as tab name

[surkdidat]

Hi

I have the formula

=VLOOKUP($A2,INDIRECT(""&$P$2&"!"&"A1:E170"),2,0)

However, I want to name the tabs by date, ie 30 April 2018, 7 May 2018, 14 May 2018 etc. I then want to reference the date in P2 to match the sheet. I understand I need to use INDIRECT and the formula works if I input the tab name as a number (ie 43220 for 30 April 2018) - however, that's not helpful when there is a mass of sheets, and trying to find the tab that corresponds to a certain date.... Any ideas appreciated!

 

[Eric W]

Try:

=VLOOKUP($A2,INDIRECT("'"&TEXT($P$2,"d mmmm yyyy")&"'!"&"A1:E170"),2,0)

 

[surkdidat]

Lovely - works a treat

Try:

=VLOOKUP($A2,INDIRECT("'"&TEXT($P$2,"d mmmm yyyy")&"'!"&"A1:E170"),2,0)