Forum Discussion
How to auto-fill terms in excel with special logic
There are two sheets in my Excel, the first sheet is a lot of different data, the second one I put the information I need in order. How could I let the Excel auto-fill the second sheet with the ...
It's a separate sheet
Do you mean collect data from Sheet1 to Sheet2 ignoring Sheet3?
SergeiBaklan Yes, thanks.
If you are lucky to have Excel with dynamic arrays, formula here
in B2 could be
=XLOOKUP($A$2:$A$49,Sheet3!$A$2:$A$151,XLOOKUP(B$1,Sheet3!$C$1:$F$1,Sheet3!$C$2:$F$151))and drag it to the right.