I have a file that references another tab. I have done all the obvious
things to be able to see other tabs; to no success.

The formula is "=LOOKUP(Q4,Items!$A$3:$A$50,Items!$B$3:$B$50) "

I know the tab is contained within this worksheet because the cell changes
if I change the reference in the formula.

I do not see the "Items" tab but I really need too. Does anyone have any
suggestions.