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