I am exporting data from a database. There are 3 columns which contain True or False depending on a database tag. The columns are labeled High, Medium and Low.

the following works well but only finds data in 1 column:

=IF(ISERROR(SEARCH("True",AO2)),"","High")
=IF(ISERROR(SEARCH("True",AP2)),"","Medium")
=IF(ISERROR(SEARCH("True",AQ2)),"","Low")

I know I can do this for each column as above and merge the results but it would be great to do this in one statement if possible.

I hope someone can help.

Thanks

Simon