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.

I think I got it.

=IF($A13=$A$330,0,IF(VLOOKUP($A13,'Sales Output Fronter'!$A$2:$A$153,1)<$A$13,0,INDEX('Sales Output Fronter'!$B$1:$B$153,MATCH('Agent Sales'!$A12,'Sales Output Fronter'!$A$1:$A$245,0))))

Sometimes it just takes asking the question to get the answer....

=IF($A13=$A$330,0,IF(ISERROR(VLOOKUP(A13,A2:A153,1 ,0)),0,INDEX($B$1:$B$153,MATCH($A13,$A$1:$A$245,0) )))

Try this you're not using formula correctly without closing the paranthesis. try this will work.

if you still face any issue send me the sheet

Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl