Hi,
How can i get IFS combined with sumproduct to spill?
Challenge. I Search for an value, concatenating multiple columns. If I find it I return the header of the column.
Using IFS(SUMPRODUCT(--ISNUMBER(SEARCH('Til opplasting'!U2#;Rapport!A:A&Rapport!B:B&Rapport!Q:Q)));Rapport!Q1
The next is similar just combined with anothe column.
Best Regards
- Geir