HI I am looking for some help, I have an excel with AND formulas from Column to Column AQ through AZ which returns True or False.
Now for example IF AQ = FALSE and AR = TRUE " The lookup should come up with header of Column AR since the check is TRUE.
If any criteria below is a match or multiple it should come up with the header example AN and AP is a match it should return as AN, AP something like this is this even possible
Below are the criteria.
<tbody>
</tbody>
Now for example IF AQ = FALSE and AR = TRUE " The lookup should come up with header of Column AR since the check is TRUE.
If any criteria below is a match or multiple it should come up with the header example AN and AP is a match it should return as AN, AP something like this is this even possible
Below are the criteria.
AN | "FALSE" |
AO | "TRUE" |
AP | "FALSE" |
AQ | "TRUE" |
AR | "TRUE" |
AS | "TRUE" |
AT | "TRUE" |
AU | "TRUE" |
AV | "TRUE" |
AW | "TRUE" |
AX | "TRUE" |
AY | "TRUE" |
AZ | "TRUE" |
<tbody>
</tbody>