I have a workbook with two spreadsheets. Sheet1 includes two columns as below. Column F is a drop down list based on named range on sheet 3 and Column G is xlookup formula as below.
=XLOOKUP([@CUSTOMER],CustomerTable1[Customer], CustRange,"")
When a customer already on the drop down list...
