Forum Discussion

iz_1977's avatar
iz_1977
Copper Contributor
Jul 20, 2022

One (1) unique ID for reference with two (2) data return (or) - Xlookup formula

Hi,

I need help with the formula for Xlookup. My data have One (1) unique ID for reference, which will also show multiple data names as returns. I require the data can be selected as either A or B.

 

Unique ID: Telco-01

Return Data: Main Office Link or Main Office (Backup Link)

 

 

Formulas and Functions

2 Replies

  • Harun24HR's avatar
    Harun24HR
    Silver Contributor
    Jul 20, 2022
    You didn't mention what problem you facing with XLOOKUP(). Can you show few sample input data then desired output by formula?
    • iz_1977's avatar
      iz_1977
      Copper Contributor
      Jul 20, 2022

      Harun24HR 

       

      Hi. Sorry. My argument was

      "=XLOOKUP(E9,'Y:\DB Files\DB\[Database Sites.xlsx]Site Master list'!$C:$C,'Y:\DB Files\DB\[Database Sites.xlsx]Site Master list'!$B:$B,,1,-1)"  

       

      yet I need the data to return as multiple choice (choosable) which IF inserted "AA-01" it will return as "Main Office Link" or " Main Office Link (Backup).  Please assist. Thank you.