Forum Discussion

sruk89's avatar
sruk89
Brass Contributor
Aug 22, 2023
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 Template Gen and Reference from Columns B,C,D & E on Tab Planned 2b Migrations

 

Image 1: Cell D7 (Template Gen)

 

Image 2:

 

So in this instance if EMLONGE, EMSANDI, EMKGWOR or EMDRAYC appeared in Cell D7 on the Template Gen Tab, I wanted it to return the value in Cell F on Planned 2b Migrations.

 

 

Any help with be greatly appreciated.

 

Regards,

Scott

 

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Aug 22, 2023

    sruk89 

    =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, ""))))

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 22, 2023

    sruk89 

    =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, ""))))