Hey everyone, I've done extensive looking on this and can't seem to find what I'm looking for. I think the answer might be in "IFERROR", but I can't seem to get this doing what I want it to do. Hoping someone has a quick answer.

A | B | C | D |
Sunroof | NAV | Bose | Rear CAMERA

Currently my formula is =IF(MATCH("*Camera",A2:D2,0),"Rearview Camera","No Rearview Camera")

This is returning a value of "Rearview Camera" in the cell.

But what I want it to do is this: If there is no Camera, then I want it to return the sunroof. So I tried the following nested if statement, but it's generating "N/A"

A | B | C | D |
Sunroof | NAV | Bose | 16" Wheels
=IF(MATCH("*Cam",A2:D2,0),"Rearview Camera",(IF(MATCH(sunroof,A2:D2,0),"Sunroof","No Features Found")))

It's generating a "Value Not Available" Error

Any thoughts? Help would be greatly appreciated.