Excel Formula

[mollyis1]

I have a spreadsheet where a column contains identical cells with a drop down of choices. When a choice is made, I would like a cell in another column to default with particular data. Example: D11-D43 all have a drop down menu with identical choices. When a selection is made in D11 (FCT) I would like for B11 to default particular data (CSERV02000). If D11 = FSP I want B11 to = CSERV04000, etc. Is this possible?

 

[BenMiller]

Do you have a lookup table with all the values and the corresponding matches? If yes, use the VLOOKUP formula.

 

[Oeldere]

[INDENT]Do you have a lookup table with all the values and the corresponding matches? If yes, use the VLOOKUP formula. [/INDENT]

If no, make such a table.

 

[T. Valko]

I have a spreadsheet where a column contains identical cells with a drop down of choices. When a choice is made, I would like a cell in another column to default with particular data. Example: D11-D43 all have a drop down menu with identical choices. When a selection is made in D11 (FCT) I would like for B11 to default particular data (CSERV02000). If D11 = FSP I want B11 to = CSERV04000, etc. Is this possible?

See this...

http://contextures.com/xlFunctions02.html

 

[mollyis1]

I appreciate the replies. I'll take a look to see if I can make this work. I may be back if I have more questions. Thanks!

 

[T. Valko]

I appreciate the replies. I'll take a look to see if I can make this work. I may be back if I have more questions. Thanks!

Just let us know if you need further assistance.