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 1st sheet data?
If excel can't do it, Access is also OK. (I have access to Access).
Detail please see the Excel I upload
9 Replies
I think VLOOKUP does it, unless there's something I'm missing. See the attached. It's not "auto-fill" per se, but it provides the information requested.
mathetes Thanks, I will check later, I think that works!!!
- INDEX/MATCH should do the job
- It's a separate sheet
Do you mean collect data from Sheet1 to Sheet2 ignoring Sheet3?
