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
Bookmarks