Forum Discussion
Solved
** HELP ** Need to retrieve date
Hi All, Im quite adept with Xlookup and index/match but i cant quite work out the formula for what im trying to achieve. I need the formula to reference what ever is in Cell D7 on Tab Temp...
=XLOOKUP(D7, 'Planned 2b Migrations'!B:B, 'Planned 2b Migrations'!F:F, XLOOKUP(D7, 'Planned 2b Migrations'!C:C, 'Planned 2b Migrations'!F:F, XLOOKUP(D7, 'Planned 2b Migrations'!D:D, 'Planned 2b Migrations'!F:F, XLOOKUP(D7, 'Planned 2b Migrations'!E:E, 'Planned 2b Migrations'!F:F, ""))))
=XLOOKUP(D7, 'Planned 2b Migrations'!B:B, 'Planned 2b Migrations'!F:F, XLOOKUP(D7, 'Planned 2b Migrations'!C:C, 'Planned 2b Migrations'!F:F, XLOOKUP(D7, 'Planned 2b Migrations'!D:D, 'Planned 2b Migrations'!F:F, XLOOKUP(D7, 'Planned 2b Migrations'!E:E, 'Planned 2b Migrations'!F:F, ""))))
Many thanks Hans!