Forum Discussion
Need IF VLOOKUP to search more than just the first occurrence of unique ID
IF VLOOKUP is only searching the first occurrence of the unique ID rather than searching until it finds the unique ID that meets the IF criteria and returning that single result. Context - I have...
SOLVED!
Solution was to make a helper column CONCATENATE(ing) the unique ID with the yes/no column and then VLOOKUP from that instead.
With INDEX/MATCH, or better with XLOOKUP if available for you, you may avoid helper column working with concatenation of main columns directly in formula
=INDEX(lookup_column,MATCH(value & "yes",IDcolumn & yes/noColumns,0))Thanks for this suggestion.
How would you deal with this in the scenario of the attached file were you would need to use <> to search within a date range.
That could be
=SUMPRODUCT( ($A$3:$A$8=G5)* ($B$3:$B$8<=H5)* ($C$3:$C$8>=H5)* $D$3:$D$8 )here
