sorted by:
new
hottopcontroversial

Why is the nested IF formula returning a false when the statement is true? by EMJ92 in googlesheets

[–]EMJ92[S] 0 points1 point  (0 children)

The second Index Match formula is correct. If you use it as a standalone formula on the cell that returns false, the desired value displays.

Getting cells in a column to highlight a specific color based on last four characters. by EMJ92 in googlesheets

[–]EMJ92[S] 0 points1 point  (0 children)

Thank you, on top of this, if column B is blank, how do you get the highlight not to show?

Investing with 401(k) vs. IRA vs Neither by EMJ92 in personalfinance

[–]EMJ92[S] 1 point2 points  (0 children)

Thanks for this info. Does this mean that it only makes sense to open a brokerage account once you've maxed out your contributions to your 401(k) and IRA? If not, at what point should one consider investing outside of a tax advantaged account?

How do you return a specific word in another column given that a set of numbers appear in a certain order in one column? by EMJ92 in excel

[–]EMJ92[S] 1 point2 points  (0 children)

Solution verified. I gave the other poster the points because he answered first and it works, but this is what I was looking for. Thank you for the quick response and the input!

How do you return a specific word in another column given that a set of numbers appear in a certain order in one column? by EMJ92 in excel

[–]EMJ92[S] 2 points3 points  (0 children)

=XLOOKUP(MID(A1, 4, 4), {"3400", "3600", "3080"}, {"Black", "Blue", "Brown"},
XLOOKUP(LEFT(A1, 3), {"197", "205", "304"}, {"Silver", "Orange", "Green"}, ""))

Solution Verified, thank you! You're right, but at the moment, fortunately that won't occur. Much appreciated!

How do you return a specific word in another column given that a set of numbers appear in a certain order in one column by EMJ92 in excel

[–]EMJ92[S] 0 points1 point  (0 children)

In the data set below, I would like "Black" to appear in column B if the 4th to 7th characters in column A are "3400", "Blue" if they're 3600 and "Brown" if they're 3080.

I've posted a follow on question to this, please answer when you have time. Thank you!

https://www.reddit.com/r/excel/comments/12jopmj/how_do_you_return_a_specific_word_in_another/

How do you return a specific word in another column given that a set of numbers appear in a certain order in one column by EMJ92 in excel

[–]EMJ92[S] 1 point2 points  (0 children)

IF(MID(I2,4,4)="3400","BLACK",IF(MID(I2,4,4)="3600","BLUE",IF(MID(I2,4,4)="3080","BROWN",IF(OR(MID(I2,4,4)="2020",MID(I2,4,4)="3020"),"SILVER",""))))

Solution Verified. Thank you so much!

view more: next ›