Need formula to compare multiple cells

[oconee1985]

Hi, I have a little experience with Excel but im stumped with this even after googling. I need a formula that does the following.

Formula Cell is located in A1

Cells H1, H2 & H3 will have either a true or false value. If one of them is true I need A1 to return a text string as listed below. Note only one of the H cells could have a true value.

H1 if true A1 would be abc (if false no text)
H2 if true A1 would be def (if false no text)
H3 if true A1 would be ghi (if false no text)

[benishiryo]

welcome to the forum. try:
=INDEX({"abc","def","ghi"},MATCH(TRUE,H1:J1,0))

if possible to have no TRUEs, then:
=IFERROR(INDEX({"abc","def","ghi"},MATCH(TRUE,H1:J1,0)),"")

[oconee1985]

Thanks but that returned an error. And it is possible for the H cells to be all false. Question regarding the formula the cells are H why the J1?

[benishiryo]

sorry ranged the wrong cells. i have uploaded an example.
=IFERROR(INDEX({"abc","def","ghi"},MATCH(TRUE,H1:H3,0)),"")

next time though, do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

[oconee1985]

That still returned an error. Hopefully I followed the upload instructions correctly. Appreciate the help.

[JeteMc]

In the case of your file the true's and false's are text strings as opposed to Boolean values which would have displayed in all capital letters in cells H1:H3
Modify Ben's formula accordingly: =IFERROR(INDEX({"abc","def","ghi"},MATCH("true",H1:H3,0)),"")
Let us know if you have any questions.

[TheChatty]

Îf you want to get rid of the three intermediate cells you can do it all in one formula:
=INDEX({"abc","def","ghi"},SUM($J$3>=0,$J$3>25000,$J$3>50000))

If you want to account for negative values as well:
=INDEX({"","abc","def","ghi"},SUM(1,$J$3>=0,$J$3>25000,$J$3>50000))