Hello!

I find some ways on the internet for multiple look up values and multiple results but I can't understand them to apply on my table. Can you help me?
I have a file that has five sheets with same columns from A to W and different data. I need a way that will, according to statuses in columns A, return all the rest values of that row in a sixth sheet. I need only three of the statuses returned in sheet six.
There are four requirements:
1. If I change status in column A Sixth sheet is updated;


2. The returned values are in the same fill color as the original cells;
3. There are no gap rows in the returned values;
4. The returned values list is sorted by column S.
It's soooo complicated. Is it even possible?

This is similar but how can I change it to do what I need?
https://www.msofficeforums.com/excel...fic-value.html

P.S. I need only certain columns returned but the other ones I can hide if needed. Probably choosing specific columns will make it much more complicated than it already is.

Attached Files

Book01.xlsx (15.1 KB, 16 views)