Hi, trying to teach myself Excel but got thoroughly stuck on a particular formula where i'm trying to enter text into a column, then have the next column use that text to fill itself based on defined list.
Since i'm sure that wasn't very clear, i've attached a small sample of what i'm trying to do. On the right side i'll have a set of defined values which won't change.
On the left side i have values that i'll input manually, but columns C & D will auto-fill via a formula based on the text in column B.
So, Example1 is what i would enter manually, Example2 is what it should auto-fill to look like with the appropriate formulas entered for columns B & C.
I tried the formula
=IF(EXACT(B4, !K:K), !L:L, "")
but to no avail...and none of the other formula conditions looked like what i was trying to do.
Any help would be greatly appreciated, this is clearly over my head.
Bookmarks