Vlookup Match and Index Assistance
I am working on a ranking spreadsheet, and I need to be able to lookup names from the sheet to the names on the sales data. If the name does not exist, I need a return of 0. This formula is as close as I have come to success, but it returns a N/A? value.
Any help is appreciated.
=IF($A13=$A$330,0,IF(ISERROR(Vlookup('Agent Sales'!$A13,'Sales Output Fronter'!A2:A153,1)))(INDEX('Sales Output Fronter'!$B$1:$B$153,MATCH('Agent Sales'!$A13,'Sales Output Fronter'!$A$1:$A$245,0))))
If value is empty, return 0, otherwise lookup value in list. If value does not exist, return 0, otherwise pull sales data from column.
|