How to populate a cell thru different choices in a drop down

[FLEETWASH]

Hello.
On my first page, I have a summary that will be pulling information from the other worksheets in my workbook.

For example, Cell A15 asked for MCC Type. CelB15 gives the user 2 choices, Standard or Form 4 (in the form of a drop down box).

My question is this. I would like to make cell G15 automatically populate, based on the drop down box. Another worksheet has information where, if the user chooses STANDARD, I would like Cell G15 to insert answer from another page, cell G4, if they choose Form 4, the answer should be pulled from the other worksheet, Cell G5.

What is the formula for this?

I hope I have explained it well.

Kate

[bigroo1958]

Fleetwash, welcome to the Forum!

Can you please post an example of your data to better understand what you wish?

[jeffreybrown]

Hi Kate,

If I read your requirements right, here is one way...

=CHOOSE(MATCH(B15,{"Standard","Form 4"},0),Sheet2!G4,Sheet3!G5)

Basically looking at cell B15 for either Standard or Form 4. When a match is made, either Sheet2 G4 or Sheet3 G5 is chosen.

A good way to see what a formula is doing is by using Evaluate Formula...

Evaluate Formula

• Click on the cell with the formula >> Ribbon >> Formulas >> Formula Auditing >> Evaluate Formula

[FLEETWASH]

hey all,

I have attached 2 views of the spread sheet I am working in. the first, sheet 1 shows my cover page where I want all my formula/ answers to be. the user would choose an answer to the question in Column B and that answer would automatically populate the G coloumn with information from other sheets.

Sheet 2 shows an example of where the information is to come from.


Sorry if I'm not being very clear.
Kate

[jeffreybrown]

Hi Kate,

Sorry, but images sometimes do us no good. We can't test possible solutions against a picture unless we re-type everything ourselves.

How about a sample workbook...!

[FLEETWASH]

pLEASE SEE ATTACHED.

[bigroo1958]

Hi Kate,

I looked at you question this morning!
Based on the formula JeffreyBrown supplied and according to my understanding of what your desired end result is to be, you pretty much worked it out yourself within Quote Sheet G15. I did notice when I downloaded the file, the drop-downs did not work for some reason, you may have another sheet not included on this workbook that held the drop down information, just my guess, I just re-created them under column O.