Greetings,

I have the following formula, but it only returns one value although the
search criteria appears more than once in the array:

IF(ISNA(VLOOKUP(A14,'21'!$B$8:$H$53,7,FALSE))=TRUE ,0,VLOOKUP(A14,'21'!$B$8:$H$53,7,FALSE))

Currently, this formula looks up a name in a different worksheet within a
workbook, in this case the worksheet tab labeled "21". I want it to add the
dollar amounts for every item in column 7 for each instance the name appears
in the B column instead on only returning the first value obtained when the
name is found in column B. Please help! I have a bit of a deadline.

Thank you for your time.