Index Match formula.xlsx
The attached file has two worksheets: Invoice Log and Match.
I need a formula for column G in the Match worksheet. It should look up the Doc # and give me the invoice number in the Invoice Log sheet that matches this doc number.
The formula I used is: =IF($S5="","",IF($B5="Invoice Pmt",INDEX('Invoice Log'!$C$4:$C$90,MATCH($C5,'Invoice Log'!$AI$4:$AI$90),0)))
As you can see in the Match sheet in cell G11 I am not getting the correct result. The formula should be returning the invoice numbers I manually entered in col AF (This column is just to show what the formula result should be. It will not be included in the final file.)
Thanks for anyone who can tell me why my index match formula is not always working.
Bookmarks