IF statement that looks for specific text output of another cells formula

[cyrusbyte]

I am trying to find a way to get the equivalent of this to work:
In cell A1 a formula that outputs text based on values looked up from other sheets (can't be changed)
In cell B2 a formula that will output another value if the text value in A1 equals specific text
here is what I would have thought would worked but apparently it is looking at the formula and not the text output.
=IFERROR(IF(B2="Text","Text1","Text2"),"")

i can do the same thing if the first formula output numeric values by using the value command like this:
=IFERROR(IF(VALUE(B2)=12,"Text1","Text2"),"")

So is there a Value equivalent for text output?

It is not possible to change the first formula, or duplicate the first formula to output numeric values.

[Jonmo1]

The only reason this formula would not work as you expect is if B2 does not actually = "Text"
=IFERROR(IF(B2="Text","Text1","Text2"),"")

Check B2 for exact spelling, and extra spaces like "Text" vs "Text " vs " Text"

[cyrusbyte]

That was actually one of the first things I checked. I double checked this by copying and paste Values and it works off of the values just not the formula. I didn't think to test to see if the formula worked the way i expected by creating a simple formula but i did and it does work with another formula that outputs text.. so there is something weird that is keeping it from working with the original formula. Ill see if i can section the original formula to see if i can find the culprit or if its a weird bug.

[Jonmo1]

Well, it's hard to say what's wrong without actually seeing your sheet.
But I can assure you, the formula is looking at the VALUE of B2, not the formula.
Assuming the formula in B2 is actually working (you see the formulas result in B2, not B2's formula)


can you post a sample book?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[cyrusbyte]

Ok this is strange, I copied the formulas exactly to a new workbook (at first only the first few rows because of the size so i could upload it) and it started working.. I then expanded the tables to the max and it still worked. SOOOO.. seems there is something corrupted in the original. Well, I feel silly now.. I just assumed I was doing something wrong.

Well thanks for all the help.

[Jonmo1]

You're welcome.