Forum Discussion
IF FORMULA
Hi I have been using an IF formula but I cant figure out how I can get it return text from another cell. example I have a list of names in column A and in columns B-F I have a yes or no next to the ...
If you have Microsoft 365 or Office 2021, enter the following formula in for example H1:
=FILTER(A1:A1000, (B1:B1000="Yes")*(C1:C1000="Yes")*(D1:D1000="Yes")*(E1:E1000="Yes")*(F1:F1000="Yes"), "")