I am trying to Match 2 criteria and return a result based on those 2 criteria matching. Ex. match part #, AND PO#, and return the date. Here is how I have the formula setup now, which is returning an NA error;
INDEX('sheet1'!DATE,MATCH(B34,'sheet1'!PART_NO.),MATCH(R34,'sheet1'!PO,0))
B34=PART #
R34=PO#
The referenced workbook has named ranges, that's why I am not using column ranges here.
Bookmarks