How to Index from multiple sheets ?

**exocide** · 03-02-2023, 04:16 AM

Hi guys, I need you help, I'm going to index a table reference, but I don't know the right way to do it. Look at this problem first :
For Example, I have 2 sheets.
Sheet 1
01/01/2023 Apple
02/01/2023 Banana
30/01/2023 Mango
I make a table reference called Sheet1Jan

Sheet 2
02/01/2023 Watermelon
13/01/2023 Pear
29/01/2023 Orange
I make a table reference called Sheet2Jan

In Sheet 3, what I'm trying to achieve is, combine them all, but with using INDEX so the data is dynamic.
Sheet 3
01/01/2023 Apple
02/01/2023 Banana
30/01/2023 Mango
02/01/2023 Watermelon
13/01/2023 Pear
29/01/2023 Orange

How to do that ? Even better if we can sort it based on the date.

I already tried using this formula

Please Login or Register  to view this content.

But the problem is, the ROW count is continuing at the beginning of Sheet2Jan reference.

Thanks if somebody can help me out.

**Glenn Kennedy** · 03-02-2023, 04:21 AM

Hi there.

1. A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

2. Is your forum profile showing the Excel PRODUCT that you need this request to work with?

The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

Cheers,

Glenn.