Forum Discussion
Matching data across tabs
I asked my secret contact at Microsoft:
Sure, I can help with that. You’re correct that you can use the INDEX and MATCH functions in Excel to achieve this. Here’s how you can do it:
- Click on the cell in Tab 1 where you want the date from Tab 2 to appear.
- Enter the following formula: =INDEX('Tab 2'!J:J, MATCH(A1, 'Tab 2'!A:A, 0))
Here’s what this formula does:
- MATCH(A1, 'Tab 2'!A:A, 0) looks for the value in cell A1 of Tab 1 within column A of Tab 2. It returns the relative position of the matching value within column A of Tab 2.
- INDEX('Tab 2'!J:J, ...) returns the value in column J of Tab 2 at the position returned by the MATCH function.
Please replace 'Tab 2' with the actual name of your second tab.
Remember to press Enter after typing the formula. Excel should now display the date from Tab 2 in the selected cell of Tab 1 whenever there’s a matching reference number.
Let me know if you need further assistance! 😊
I asked my secret contact at Microsoft:
Sure, I can help with that. You’re correct that you can use the INDEX and MATCH functions in Excel to achieve this. Here’s how you can do it:
- Click on the cell in Tab 1 where you want the date from Tab 2 to appear.
- Enter the following formula: =INDEX('Tab 2'!J:J, MATCH(A1, 'Tab 2'!A:A, 0))
Here’s what this formula does:
- MATCH(A1, 'Tab 2'!A:A, 0) looks for the value in cell A1 of Tab 1 within column A of Tab 2. It returns the relative position of the matching value within column A of Tab 2.
- INDEX('Tab 2'!J:J, ...) returns the value in column J of Tab 2 at the position returned by the MATCH function.
Please replace 'Tab 2' with the actual name of your second tab.
Remember to press Enter after typing the formula. Excel should now display the date from Tab 2 in the selected cell of Tab 1 whenever there’s a matching reference number.
Let me know if you need further assistance! 😊
