=SUMPRODUCT(dollars*(ISNUMBER(MATCH(terr,{3,5},0)) ))

=SUMPRODUCT(B2:B6*(ISNUMBER(MATCH(A2:A6,{3,5},0))) )

HTH
Kostis Vezerides

On Jan 26, 6:41 pm, fomo wrote:
Hello,

I am trying to figure out a way to get around this type of formula:

=vlookup(3,dollars,2,false)+vlookup(5,dollars,fals e)

here is a sample of the dollars range:

Terr# dollars
1 100
2 75
3 150
4 300
5 85

What I would really like is this to work with one formula instead of adding
formulas as above.....something like:

=vlookup({3,5},dollars,2,false)

This only returns the first instance of terr# 3 ( 150 )....when I want to
add terr#'s 3 and 5 ( or more in my actual scenario )

Please help and THANK YOU!