Forum Discussion

sruk89's avatar
sruk89
Brass Contributor
Oct 25, 2023
Solved

** HELP ** Multiple XLOOKUPS

Hi HansVogelaar,   You have helped me before with a similar request, so hoping you could help me out with this one too.   The idea is the xlookup is referencing cell b2 and looking in the 3 tabs ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Oct 25, 2023

    sruk89 That shouldn't be a problem since we look for the 2b migrations first. But the formula has to be modified for the planned migrations sheet (my mistake):

     

    =IFS(ISNUMBER(MATCH(B2, 'Sacramento Migrated Exchanges'!A:A, 0)), "2b - Migrated", COUNTIF('Planned 2b Migrations'!B:J, B2), "2b Migration - Planned", ISNUMBER(MATCH(B2, 'Ready for Config - On Hold'!A:A, 0)), "2a Migration", TRUE, "-")

     
sruk89's avatar
sruk89
Brass Contributor
Oct 25, 2023

HansVogelaar ,

Sure, no problem.

So, on the "Ready for Config - On Hold" Tab it may also contain the same code that we are referencing from Cell B2 on the Planned 2b Migration

Blue Circle = MRHUL (Not on Planned 2b) therefore this would be 2a

Red Circle(s) = CLBER/LNWIN(Which is on the Planned 2b Migrations)

Ready for Config - On Hold Tab:

Planned 2b Migration Tab: (MRHUL) is not on this list

 

 

 

 

HansVogelaar's avatar
HansVogelaar
MVP
Oct 25, 2023

sruk89 That shouldn't be a problem since we look for the 2b migrations first. But the formula has to be modified for the planned migrations sheet (my mistake):

 

=IFS(ISNUMBER(MATCH(B2, 'Sacramento Migrated Exchanges'!A:A, 0)), "2b - Migrated", COUNTIF('Planned 2b Migrations'!B:J, B2), "2b Migration - Planned", ISNUMBER(MATCH(B2, 'Ready for Config - On Hold'!A:A, 0)), "2a Migration", TRUE, "-")

 

Resources