Forum Discussion
Requesting formula to copy from one tab to another
Hijenniferk007,
it doesn't work quite as elegantly in Excel as it does in Google Sheets with Query. But there is also a solution with FILTER() in a single cell. I have built an example file for you. Here you will find the formula in cell Tab2!A2.
If you make a table out of the data, as in my example, you can restrict the cell ranges even more easily. But here I would use three formulas. Each for the entry from column A, C and D (in E2, F2 and G2).
Restricting the rows makes sense. If you were to apply the filter over the whole table, it would be very detrimental to performance. In the one-cell solution, I worked with LET() and LOOKUP() to find the last entry in column K and thus restrict the table range.
Have a look at my example to see if you can do something with it. Good luck.
- Thank you, I will give this a try.
Using OneDrive, I was successful in getting the formula to work dynamically. However, there are still some outliers to be fixed. Namely, it appears that the header in columns 4 and 5 on Sheet 2 are being truncated. I don't understand the formula enough to see why. There is also an error in 2.3.e, where I assumed missing information from Tab1. But that row has all the information being requested in the formula.
https://1drv.ms/x/s!AkS7DYdbFniAfr4R2wFMdjMegEQ?e=Qqx352
Hi jenniferk007 ,
We have already "chatted" with each other in your document. One problem is that Filter() can only return cells with a maximum of 255 characters. The truncation of the cell headers was a problem with the display and column width. I don't know if this is a specific Excel for Web problem. If you increase the column width, you can read your headings.
Otherwise, you have adapted the formula well to your table.
