IF(ISERROR) formula

[mannyz8]

Good afternoon,

I have this formula that got created last year, but the end result needs to change from what the current text is presenting.

My current text reads: "Released", "Closed", and Technically Complete" once the data is pulled from the vlookup;

=IF(ISERROR(VLOOKUP(I7,'TTA UBW Report'!D:I,6,FALSE)),"NONE",(VLOOKUP(I7,'TTA UBW Report'!D:I,6,FALSE)))


I'm trying to change the text to read the following;

Change from "Released" to "REL", "Closed" to "CLD", and "Technically Complete" to "TECO"

Any suggestions it would greatly be appreciated, spent a few hours researching and trying out formulas but no luck.

Thank you.

[Jonmo1]

I would suggest doing the conversion on the TTA UBW Report sheet..
Put the respective 'alternate' strings in an available column for each row there..
Then adjust your vlookup to return that column.

Can you post a sample book?

[mannyz8]

great suggestion Johnmo1, thank you.

[mannyz8]

sorry, Jonmo1

[Jonmo1]

You're welcome.