This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm sure I've used the =Filter function before, but I just cannot get it going this time. I'm trying to get all the data that matches from one table to spill in another sheet. The table name and column name are correct. This is the formula
=FILTER(tblMain,tblMain[Portal]="Hanson")
It just returns #Ref. I even remade the table, thinking there might be some weird error, but it didn't help. Any advice on what the heck I'm missing?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
Either the tblmain table has been deleted or does not exist. Same for the Portal column. Please recheck.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Any chance you can post a suitably censored file somewhere (Onedrive/dropbox etc) that I can have a look at?
Are there any #REF! errors in the Portal column?
No, it's not even a formula column. Just straight text. Nothing in tblMain is a formula actually.
Are there any #REF! errors in the Portal column?