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 am using this formular it wrorked for my previours sheet. I use it again but it always trun #VALUE error. My formular is
=FILTER(VSTACK(Jan:Dec!A3:S150),(VSTACK(Jan:Dec!A3:A150)<>"")*(VSTACK(Jan:Dec!I3:I150)=B2),"No Results")
I have check all my sheets no spaces no number it is a blank sheets could anyone please help ?
Thank you!
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,
You may want to consider the alternative of append data from multiple tabs into a single table by following the steps shown in the video here. Once you have a single, table, you can write formulas/create Pivot Table.
We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.