I have a match formula that works fine, but my spreadsheet is kinda funky. I want to use this formula, but go down 2 cells and pull that number.
Example:
If this formula finds the total in row L33, then go down 2 more rows and pull that number L35.
=IF(ISNUMBER(MATCH(C33,'COUPON DATA'!B:B,0)),INDEX('COUPON DATA'!L:L,MATCH(C33,'COUPON DATA'!B:B,0)))
I hope this can be done. Sure would help me.
I'm using 2010 version.
Bookmarks