Trouble with formula

dharberts

Trying to have a cell either bring back what is on another sheets cell or bring back a statement

IF(ISBLANK({Tablet Device Lang}), INDEX({Tablet Device Lang}, MATCH(Country@row, {Study Country, Device, MDM List l Country}, 0)))"No Language Assigned for this Country - Contact Device PM")

Receiving:

#UNPARSEABLE

Paul Newcome

Try

=IF(INDEX({Tablet Device Lang}, MATCH(Country@row, {Study Country, Device, MDM List l Country}, 0)) <> "", INDEX({Tablet Device Lang}, MATCH(Country@row, {Study Country, Device, MDM List l Country}, 0)), "No Language Assigned for this Country - Contact Device PM"))

dharberts

I did that formula and still receiving #UNPARSEABLE

Paul Newcome

My apologies. Remove one of the closing parenthesis from the very end of my formula.

dharberts

OK if there is no country at all then I'd like it to come back as a blank space, then it should be complete. Your update helped, thank you

Paul Newcome

In that case you can wrap it in an IF statement.

=IF(Country@row <> "", .......................)