Jul 20 2022 05:44 PM
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)
Jul 20 2022 08:50 PM
Jul 20 2022 10:53 PM
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.