Can someone help me with this one?

I want to write a function similiar to Vlookup;
Except it should be able to take more than one lookup value and the
add the values returned;

For Example
Column A Column B
Acc100 R 1000
Acc200 R 2000
Acc300 R 3000
Acc400 R 4000

The function should search Range(A1:B4) for say Acc100 and Acc300 an
then add the corresponding values from Column B
R1000 + R 3000 ;

Thanks

--
Message posted from http://www.ExcelForum.com