Hey folks,

Hopefully I explain this well. I am playing around with xlookup and data validation lists and can’t seem to accomplish what i am trying to do.

Simply put, i want a tailore list of options in a dropdown of a cell to be relative based on the value of another cell, however the cell it is referencing is the return from another xlookup.

Here is the contents I want to appear in the dropdown of Column B. You can see there are 4 different column list (on a different tab of the original sheet), and I want the cell to only have one of these columns available based on the criteria that appears in another column in this same sheet.

This is column B where i want the list to appear with its dynamic options, so we can see Audit Detailed options now but if AUP - Simple were to appear in column K (image below) i would want only Perform AUP Procedures to appear as an option in this drop down.

This is the column I want to reference to change the dependent list option in column B, however i think i am having issues because as you can see the data return in the cell is correct but up in the function bar is the formula because this column is the return of another Xlookup.