software

I am trying to build a form with certain blocks that will be filled by the
user making a choice from a list of options and reasons for thoses options on
another sheet. Example would look like this

Sheet 1 (The main form)
______ Please pick from the list what State you are from (When they click on
this box, it will give them the choices and reason from sheet2)Sheet 2
Col 1Col 2
DataReason for selection
8Select this one if you are from CA
9Select this one if you are from FL
10Select this one if you are from MA

I don’t want the use to be able to enter any thing other than their choice
from the options given. When they make their selection, the number from
sheet2, column 1 would be entered on to sheet 1. Can anyone help me with
this…Any help would be greatly appreciatedI would of thought some Excell experts out there would of told me how to do
this by now! Can anyone HELP ME? I really need to get this form done and my
head is bleeding from all the bangging it in to the wall!!!

quot;Harley Riderquot; wrote:

gt; I am trying to build a form with certain blocks that will be filled by the
gt; user making a choice from a list of options and reasons for thoses options on
gt; another sheet. Example would look like this
gt;
gt; Sheet 1 (The main form)
gt; ______ Please pick from the list what State you are from (When they click on
gt; this box, it will give them the choices and reason from sheet2)
gt;
gt;
gt; Sheet 2
gt; Col 1Col 2
gt; DataReason for selection
gt; 8Select this one if you are from CA
gt; 9Select this one if you are from FL
gt; 10Select this one if you are from MA
gt;
gt; I don’t want the use to be able to enter any thing other than their choice
gt; from the options given. When they make their selection, the number from
gt; sheet2, column 1 would be entered on to sheet 1. Can anyone help me with
gt; this…Any help would be greatly appreciated
gt;

Your list in Sgeet2 should have 1 column only

You must assign a name (eg: Statesquot;) to it
(Insertgt;name)

Get back to sheet1
Select rows to be validated by drop-down list
Datagt;Validation
Select List
Enter =States in range box

Et voila!

HTH
--
AP

quot;Harley Riderquot; gt; a écrit dans le
message de ...
gt; I would of thought some Excell experts out there would of told me how to
do
gt; this by now! Can anyone HELP ME? I really need to get this form done and
my
gt; head is bleeding from all the bangging it in to the wall!!!
gt;
gt; quot;Harley Riderquot; wrote:
gt;
gt; gt; I am trying to build a form with certain blocks that will be filled by
the
gt; gt; user making a choice from a list of options and reasons for thoses
options on
gt; gt; another sheet. Example would look like this
gt; gt;
gt; gt; Sheet 1 (The main form)
gt; gt; ______ Please pick from the list what State you are from (When they
click on
gt; gt; this box, it will give them the choices and reason from sheet2)
gt; gt;
gt; gt;
gt; gt; Sheet 2
gt; gt; Col 1 Col 2
gt; gt; Data Reason for selection
gt; gt; 8 Select this one if you are from CA
gt; gt; 9 Select this one if you are from FL
gt; gt; 10 Select this one if you are from MA
gt; gt;
gt; gt; I don't want the use to be able to enter any thing other than their
choice
gt; gt; from the options given. When they make their selection, the number from
gt; gt; sheet2, column 1 would be entered on to sheet 1. Can anyone help me
with
gt; gt; this.Any help would be greatly appreciated
gt; gt;

Sir, Thank you for our reply and suggestion however I am required to have
two columns because I do not want the reason for making the selection to be
enter on to the form. I need the use to select/make a choice from column one
due to the info in column two. I would appreciate any other thoughts or
ideal you might have.
quot;Ardus Petusquot; wrote:

gt; Your list in Sgeet2 should have 1 column only
gt;
gt; You must assign a name (eg: Statesquot;) to it
gt; (Insertgt;name)
gt;
gt; Get back to sheet1
gt; Select rows to be validated by drop-down list
gt; Datagt;Validation
gt; Select List
gt; Enter =States in range box
gt;
gt; Et voila!
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Harley Riderquot; gt; a écrit dans le
gt; message de ...
gt; gt; I would of thought some Excell experts out there would of told me how to
gt; do
gt; gt; this by now! Can anyone HELP ME? I really need to get this form done and
gt; my
gt; gt; head is bleeding from all the bangging it in to the wall!!!
gt; gt;
gt; gt; quot;Harley Riderquot; wrote:
gt; gt;
gt; gt; gt; I am trying to build a form with certain blocks that will be filled by
gt; the
gt; gt; gt; user making a choice from a list of options and reasons for thoses
gt; options on
gt; gt; gt; another sheet. Example would look like this
gt; gt; gt;
gt; gt; gt; Sheet 1 (The main form)
gt; gt; gt; ______ Please pick from the list what State you are from (When they
gt; click on
gt; gt; gt; this box, it will give them the choices and reason from sheet2)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Sheet 2
gt; gt; gt; Col 1 Col 2
gt; gt; gt; Data Reason for selection
gt; gt; gt; 8 Select this one if you are from CA
gt; gt; gt; 9 Select this one if you are from FL
gt; gt; gt; 10 Select this one if you are from MA
gt; gt; gt;
gt; gt; gt; I don't want the use to be able to enter any thing other than their
gt; choice
gt; gt; gt; from the options given. When they make their selection, the number from
gt; gt; gt; sheet2, column 1 would be entered on to sheet 1. Can anyone help me
gt; with
gt; gt; gt; this.Any help would be greatly appreciated
gt; gt; gt;
gt;
gt;
gt;
gt;

Sorry, I see no solution.

Cheers,
--
AP

quot;Harley Riderquot; gt; a écrit dans le
message de ...
gt; Sir, Thank you for our reply and suggestion however I am required to have
gt; two columns because I do not want the reason for making the selection to
be
gt; enter on to the form. I need the use to select/make a choice from column
one
gt; due to the info in column two. I would appreciate any other thoughts or
gt; ideal you might have.
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; Your list in Sgeet2 should have 1 column only
gt; gt;
gt; gt; You must assign a name (eg: Statesquot;) to it
gt; gt; (Insertgt;name)
gt; gt;
gt; gt; Get back to sheet1
gt; gt; Select rows to be validated by drop-down list
gt; gt; Datagt;Validation
gt; gt; Select List
gt; gt; Enter =States in range box
gt; gt;
gt; gt; Et voila!
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Harley Riderquot; gt; a écrit dans le
gt; gt; message de ...
gt; gt; gt; I would of thought some Excell experts out there would of told me how
to
gt; gt; do
gt; gt; gt; this by now! Can anyone HELP ME? I really need to get this form done
and
gt; gt; my
gt; gt; gt; head is bleeding from all the bangging it in to the wall!!!
gt; gt; gt;
gt; gt; gt; quot;Harley Riderquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am trying to build a form with certain blocks that will be filled
by
gt; gt; the
gt; gt; gt; gt; user making a choice from a list of options and reasons for thoses
gt; gt; options on
gt; gt; gt; gt; another sheet. Example would look like this
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 1 (The main form)
gt; gt; gt; gt; ______ Please pick from the list what State you are from (When they
gt; gt; click on
gt; gt; gt; gt; this box, it will give them the choices and reason from sheet2)
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 2
gt; gt; gt; gt; Col 1 Col 2
gt; gt; gt; gt; Data Reason for selection
gt; gt; gt; gt; 8 Select this one if you are from CA
gt; gt; gt; gt; 9 Select this one if you are from FL
gt; gt; gt; gt; 10 Select this one if you are from MA
gt; gt; gt; gt;
gt; gt; gt; gt; I don't want the use to be able to enter any thing other than their
gt; gt; choice
gt; gt; gt; gt; from the options given. When they make their selection, the number
from
gt; gt; gt; gt; sheet2, column 1 would be entered on to sheet 1. Can anyone help me
gt; gt; with
gt; gt; gt; gt; this.Any help would be greatly appreciated
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
Hi there,
I don't really understand what u are looking at:
You have 2 sheets
Sheet 1 - given to the user to choose his input from validation list (code amp;
city)
Based on his choice (code / city) you need to pick up the reason from sheet2
and display next to city like below:
B4 C4 D4
CodecityReason
2City 02Reason 08
Put at D4
==INDEX(Sheet2!$D$4:$D$22,MATCH(1,(Sheet2!$B$4:$B$ 22=Sheet1!B5)*(Sheet2!$C$4:$C$22=Sheet1!C5),0))
array formula so : Ctrl shift enter
in sheet2 you will have code, city amp; reason listing from range b4:d22
in sheet2 you will have code 1,2,3 range name as code
in sheet2 you will have city city 01, city 02, city 03
in sheet2 you will have reason 01.. reason 18

Now you can copy the b4:d4 down the rows for user to select...quot;Harley Riderquot; wrote:

gt; Sir, Thank you for our reply and suggestion however I am required to have
gt; two columns because I do not want the reason for making the selection to be
gt; enter on to the form. I need the use to select/make a choice from column one
gt; due to the info in column two. I would appreciate any other thoughts or
gt; ideal you might have.
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; Your list in Sgeet2 should have 1 column only
gt; gt;
gt; gt; You must assign a name (eg: Statesquot;) to it
gt; gt; (Insertgt;name)
gt; gt;
gt; gt; Get back to sheet1
gt; gt; Select rows to be validated by drop-down list
gt; gt; Datagt;Validation
gt; gt; Select List
gt; gt; Enter =States in range box
gt; gt;
gt; gt; Et voila!
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Harley Riderquot; gt; a écrit dans le
gt; gt; message de ...
gt; gt; gt; I would of thought some Excell experts out there would of told me how to
gt; gt; do
gt; gt; gt; this by now! Can anyone HELP ME? I really need to get this form done and
gt; gt; my
gt; gt; gt; head is bleeding from all the bangging it in to the wall!!!
gt; gt; gt;
gt; gt; gt; quot;Harley Riderquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am trying to build a form with certain blocks that will be filled by
gt; gt; the
gt; gt; gt; gt; user making a choice from a list of options and reasons for thoses
gt; gt; options on
gt; gt; gt; gt; another sheet. Example would look like this
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 1 (The main form)
gt; gt; gt; gt; ______ Please pick from the list what State you are from (When they
gt; gt; click on
gt; gt; gt; gt; this box, it will give them the choices and reason from sheet2)
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 2
gt; gt; gt; gt; Col 1 Col 2
gt; gt; gt; gt; Data Reason for selection
gt; gt; gt; gt; 8 Select this one if you are from CA
gt; gt; gt; gt; 9 Select this one if you are from FL
gt; gt; gt; gt; 10 Select this one if you are from MA
gt; gt; gt; gt;
gt; gt; gt; gt; I don't want the use to be able to enter any thing other than their
gt; gt; choice
gt; gt; gt; gt; from the options given. When they make their selection, the number from
gt; gt; gt; gt; sheet2, column 1 would be entered on to sheet 1. Can anyone help me
gt; gt; with
gt; gt; gt; gt; this.Any help would be greatly appreciated
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;