Forum Discussion
Match data from another tab
Hi there, I am looking for an index and/or match formula. The first shot is tab1 and I want to enter a formula in column E that matched column D to column A in Tab 2 and returns the same GL code from tab 2 to column E. So for example the first one meals & entertainment would return code 6701 in column E. TIA
One way with data in tab2/sheet2 https://support.microsoft.com/en-us/office/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370 named 'TableGL':
in D2:
=IF([@CATEGORY] = "", "", XLOOKUP([@CATEGORY], TableGL[CATEGORY], TableGL[GL CODE], "No match") )or - with data in tab1/sheet1 not formatted as Table:
=IF(C2 = "", "", XLOOKUP(C2, TableGL[CATEGORY], TableGL[GL CODE], "No match") )
3 Replies
One way with data in tab2/sheet2 https://support.microsoft.com/en-us/office/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370 named 'TableGL':
in D2:
=IF([@CATEGORY] = "", "", XLOOKUP([@CATEGORY], TableGL[CATEGORY], TableGL[GL CODE], "No match") )or - with data in tab1/sheet1 not formatted as Table:
=IF(C2 = "", "", XLOOKUP(C2, TableGL[CATEGORY], TableGL[GL CODE], "No match") )Lorenzo thank you so much for this!!
- You're welcome & Thanks for providing feedback and marking as answered
