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!