Excel Formula Help

[Michael Spross]

This may beneath some of you geniuses, but, need your help
nonetheless. I'll try to write this out.

Column A, has a drop down to equal X, I or A.
Column B, (here's the problem), need this to grab value of Column C if
Column A equals X, grab value of column D if Column B equals I, grab
value of Column E if column equals A.

So, basically, what formula can I input into Column B to get this to
happen?

Example of what it should look like.

A B C D
E
X ValX ValX ValD ValE
I ValD ValX ValD
ValE
A ValE ValX ValD ValE

 

[Clif McIrvin]

This may beneath some of you geniuses, but, need your help
nonetheless. I'll try to write this out.

Column A, has a drop down to equal X, I or A.
Column B, (here's the problem), need this to grab value of Column C if
Column A equals X, grab value of column D if Column B equals I, grab
value of Column E if column equals A.

So, basically, what formula can I input into Column B to get this to
happen?

Example of what it should look like.

A B C D
E
X ValX ValX ValD ValE
I ValD ValX ValD
ValE
A ValE ValX ValD ValE

Try using this formula in B1 and copy down as needed:

=CHOOSE(SEARCH(A1,"xia"),C1,D1,E1)

On my computer (xl2010), if A1 is empty SEARCH returns 1 (I expected an
error) -- so you might need to add an IF or IFERROR to the formula.

 

[Michael Spross]

Thanks Clif,
This worked perfectly.