Looking for vlookup style function for multiple values

ArviLaanemets · #1 04-17-2023, 08:42 AM

Into cell B2 of your final table enter the formula

Code:

=IIF(SUMIFS(SourceDateRange, SourceNameRange, $A2, SourceCourseRange, B$1)=0,"",SUMIFS(SourceDateRange, SourceNameRange, $A2, SourceCourseRange, B$1))

, where all 3 dateranges are of same dimension, and defined using absolute references (like SourceSheet!$A$2500 for SourceNameRange, and SourceSheet!$B$2500 for SourceCourseRange, etc.).
Copy the formula to whole datarange of your final table! And format the datarange there as date!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keeping the source format when extracting data from multiple cells using Vlookup function	praboos2001	Excel	6	11-15-2016 04:40 AM
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
VLookup multiple values and Sum	tinfanide	Excel	2	09-02-2014 11:41 AM
Using vlookup with the IF function	CSzoke	Excel	11	06-01-2013 10:56 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM