Hi All - I tried using index match to return matching results for sales order# 133213 which is duplicated in the row below in Sheet 1, Column A. But it always returns only the first invoice# it could find on Sheet 2, Column A for both rows in Sheet 1, Column F. Appreciate any help, and thank you so much in advance ?
Column A | Column F | Column A | Column E |
Sales Order# | Invoice# | Invoice# | Sales Order# |
133213 | 6700000456 | 133213 | |
133213 | 6700000443 | 133213 | |
121323 | 6700000478 | 121323 | |
Sheet 1 | Sheet 1 | Sheet 2 | Sheet 2 |