Adding a form based on a lookup selection

[yvettes]

Hi,

I wondered if anyone can help please?

I want a form to appear in excel, according to the option a user has selected from a drop-down list. So, for example, if the user selects the option "Yes", form A will be displayed for completion, and if the user selects the option "No", form B will be displayed.

Thank you in advance for your assistance!

[shank_mis]

It's simple.
Write the contents of both the forms in separate columns....say column A & B.
Apply IF() formula on every cell where you want your contents to display. For example: =IF(drop-down="yes","Name","Nahme"). In this example "yes" is for english and "no" for german.
Based on the option selected from drop-down menu, contents will display.

You have not specified how your forms look and what contents you want to display.
This is just a general idea. Hope you find it helpful.

---

Shashank

[yvettes]

Thanks Shashank. I have tried using the If formula, but I am getting an error. So, I am writing =If(drop-down="yes", Sheet1!A1:D20, Sheet1!A25:D45) I am getting a value error. Do you know where I am going wrong please?

[yvettes]

The cell references being where the forms are located

[shank_mis]

Why are you selecting a range of cells ? Any particular reason for that ?
Generally we refer to one cell... For range of cells we have to convert them into array formula.

I would suggest to upload the form template here if you can. This may help us in assisting you in a better way.

---

Shashank

[yvettes]

Hi Shashank, it is because we have a range of formulas within the form which perform calculations based on the options selected. Unfortunately I can't upload the spreadsheet as it contains confidential information. Sorry if it's a sill question, but how do I convert them into an array formula please?

[shank_mis]

You don't need to upload your original sheet. Create a small template comprised of input data, data type and skeleton of output you desire.
At least, we will get an idea of your requirement.
As far as array formula is concerned, it is rather difficult to generalize because they are highly specific.

Once again, I would suggest to upload a template or provide some more details so that we may assist you.

Ta..