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 ...
INDEX/MATCH should do the job
- It's a separate sheet
Do you mean collect data from Sheet1 to Sheet2 ignoring Sheet3?
SergeiBaklan Yes, thanks.
:You say "It's a separate sheet" but don't really respond to Abiola1's suggestion of INDEX/MATCH or to mine of VLOOKUP (the two suggestions are very similar for the most part). I'm sure both he and I would appreciate a more complete response.
mathetes I would like to take a try this weekend, thanks!
