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

​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   Read More

​