Listed are the two tables that I am trying to join using a Vlookup. However, I was wondering if there was a better way to possibly get the same result using array functions in Excel.

Name Item-1 Item-2 Item-3 Item-4 Vlookup-Item-1 Vlookup-Item-2 Vlookup-Item-3 Vlookup-Item-4 Total
a 1 3 5 7 5 12 22 22 61
b 2 4 6 7 17 27 51
c 1 5 5 22 27
d 2 4 8 7 17 17 41


Item Price
1 5
2 7
3 12
4 17
5 22
6 27
7 22
8 17


I want to end up with the Total column without having to do all the different Vlookup's (Vlookup-Item-1 thru Vlookup-Item-4) and summing up the result.

Vlookup is "IF(B2>0,VLOOKUP(B2,$A$10:$B$17,2,FALSE),"")"



Any insight would be greatly appreciated.

Sudheer