I am trying to create a 3d lookup I think???
In the attached file the table of data is contained in C2:E15
The test data is from B19:D24
The formula I am seeing will be placed in D19:D24…. It is looking in the table for BOTH the date AND Lot# to give the correct USE value.
Thank you for your assistance.
Try this:
=SUMIFS($E$2:$E$15,$C$2:$C$15,B19,$D$2:$D$15,C19)
The second to last pair in your sample data have no match.
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.
WOW!!!! Amazing. Thank you!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks