=IF(AND(MATCH(B4, Sheet1!B:B, 0), MATCH(C4, Sheet1!C:C, 0)), Sheet1!G)
I get given a document every week, Sheet1, I need to match cells from columns B and C on a given row in my sheet to columns B and C on Sheet1 also ensuring that they are from a single row and then return the data on Sheet1 cloumn G from that row.
How do I make sure that the match on Sheet1 is from one row and then return the data on G?
If I could make this a vba so people don't touch it that would also be helpful.
