I've been searching high and low but have been unable to find a solution. Part of my spreadsheet has columns setup as dynamic ranges (price,desc,sku,price_desc). What I am trying to do is setup 2 data validation lists, 1 with the items less than $35 and the other with items great than or equal to $35 and the text that I want in the list is from the price_desc range. No matter what I try I can't make this happen. If anyone has input I would greatly appreciate it!
Thanks,
Adam
Bookmarks