Hi everyone,
I got below formula that works ok but I need to amend it in a way that (after matching up) instead of looking up for B4 and bringing the value in column 3, look up for B4 and bring a sum of all available values in column 3 that match B4 because there might be more than one cell that match B4.
=IF(AND(BZ$2=Result!$A$1,CA$3=Result!$B$1),VLOOKUP($B4,Result!$A$2:$C$170, 3,FALSE))
Thanks a lot
Last edited by Bobbie75; 09-22-2019 at 08:14 AM.
Are you still using Excel 2007?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this.
Formula:
Please Login or Register to view this content.
Cheers Shareez. With a bit of tweaking it worked. Thanks a lot
No. Its company's machine I'm using actually with Excel 2016.
Then you should update your user profile to reflect this, please.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks