Ecel Dumbo
Member
Hello Dear friends,
I have found this site wonderful and am learning a lot from the expert excel users in this forum. TOns of thanks
I have a attached an excel spreadhseet, where in I need to create a lookup formula with multiple conditions. The current Sum product formula I 'm using now is cumbersome and it is talking a lot of time to update the values. As time goes, I will need to add informations for the rest of the year in the source data. Once I paste the data, it takes a lot of time for me to do anything on the file.
Kindly help. Link for the file below.
http://speedy.sh/QAys5/Look-Up-with-mutiple-conditions.xls
Download at SpeedyShare
Thanks a lot.
Excel Dumbo
I have found this site wonderful and am learning a lot from the expert excel users in this forum. TOns of thanks
I have a attached an excel spreadhseet, where in I need to create a lookup formula with multiple conditions. The current Sum product formula I 'm using now is cumbersome and it is talking a lot of time to update the values. As time goes, I will need to add informations for the rest of the year in the source data. Once I paste the data, it takes a lot of time for me to do anything on the file.
Kindly help. Link for the file below.
http://speedy.sh/QAys5/Look-Up-with-mutiple-conditions.xls
Download at SpeedyShare
Thanks a lot.
Excel Dumbo