If cell contains this string then concatenate this else concatenate something else

[dougmcc1]

How would I use a concatenate function based on what string the cell contains?

For example if cell AZ contains "car" then I want my concatenate to output "Type = Car".

Else if cell AZ contains "truck" then I want my concatenate to output "Type = Truck".

Else "Type = Other".

Any example I find online always outputs the Else no matter what the cell value is, even when it should find the string.

Here's what I have:
=CONCATENATE("Type = ",IF(ISERR(FIND("car",AZ)),"Car",IF(ISERR(FIND("truck",AZ)),"Truck","Other")))

cell value for AZ is d3truckdsds

Any ideas?

[dougmcc1]

I thought maybe I had ISERROR backwards where if it DOES NOT contain the string then...

But this formula still returns "Other" as well:
=CONCATENATE("Type = ",IF(ISERR(FIND("car",AZ)),IF(ISERR(FIND("truck",AZ)),"Other","Truck"),"Car"))

Still using where cell value of AZ is d3truckdsds

[Yogi52o]

is AZ a named range, or a cell reference? If a named range, your formula should work fine...if a cell reference, then you need a row number.

Edit: See Attached.

[dougmcc1]

Wow so close. Glad it was a simple fix. Thanks for catching the error.

[ben_hensel]

Unless you've got a cell that you explicitly named "AZ", the FIND is always going to return a #NAME? error because AZ as such is not a valid cell reference.

Is it supposed to refer to AZ1 instead or something?

[Yogi52o]

My pleasure. If that solves your problem, please mark the thread as [SOLVED], and I would appreciate the reputation.