Further to my database problem …
Here is what I tried to do: 1)
Used column B in sheet 1 to ref that column in sheet 2. - worked
Used column B as a deref in sheet 1 to pull in values from sheet 2 - worked
Requested to filter the contents of column B in sheet 1 by Category.
Added a Category column to sheet 1 just before column B in the spreadsheet.
I did this and it worked beautifully.
HOWEVER … the deref’s no longer worked.
Was I putting too much on the Column B?