Search results

Wow, Aniruddah, it's working! Thank you so much!

Dear Aniruddah, Thank you for your assistance. I've attached a file with sample data so you can see how it is working -- and not working.

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...