Forum Discussion
jessg0121
Oct 05, 2022Copper Contributor
Need to tag multiple rows the same, however attributes differ except for ID (nested IF?)
I have a https://1drv.ms/x/s!AhYM9SkP8EZg2CK_jrzDb5AkWBxe?e=tYRb2P of project lines where multiple lines in the file may constitute a single project (col H has consistent budget ID) and that project ...
OliverScheurich
Oct 05, 2022Gold Contributor
=IF(SUMPRODUCT((H2=$H$2:$H$11)*($L$2:$L$11="Technology"))>0,"Yes","No")
Does this return your expected result?