Defined range using more than one column
 

Can anyone tell me if it is possible to have two or more columns in a
defined range. I want to have a dropdown validation list where two or more
columns of data is displayed on the dropdown list. When an item is selected
in the dropdown list only one of the columns data is displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down please let me know.

Thanks
Pat

You can have a defined range with two or more columns, but that won't show
up in Data=Validation using the list option. You might want to look at the
Control Toolbox Toolbar Combobox or Listbox.

When an item is selected
in the dropdown list only one of the columns data is displayed in the
cell.

It is unclear if you are saying this is what you want, or you are
complaining that this is what happens and not what you want. It certainly
is what happens and there is no way around that unless you use code to
interpret the selection and write a concatenated string of the column values
to the single cell or write the row in the combobox dropdown across multiple
cells.

--
Regards,
Tom Ogilvy


"Pat" wrote in message
...
Can anyone tell me if it is possible to have two or more columns in a
defined range. I want to have a dropdown validation list where two or more
columns of data is displayed on the dropdown list. When an item is
selected
in the dropdown list only one of the columns data is displayed in the
cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down please let me know.

Thanks
Pat

Try SUMIF. For example, let's say your dates are in col.
A, values to sum in col. B, and all this is in a sheet
named "mysheet". With a date in A1 of a new sheet, use:

=SUMIF(mysheet!A:A,A1,mysheet!B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can anyone tell me if it is possible to have two or more
columns in a
defined range. I want to have a dropdown validation list
where two or more
columns of data is displayed on the dropdown list. When
an item is selected
in the dropdown list only one of the columns data is
displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down
please let me know.

Thanks
Pat


.

Ignore this. I responded to the wrong post. Sorry.

Jason

-----Original Message-----
Try SUMIF. For example, let's say your dates are in col.
A, values to sum in col. B, and all this is in a sheet
named "mysheet". With a date in A1 of a new sheet, use:

=SUMIF(mysheet!A:A,A1,mysheet!B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can anyone tell me if it is possible to have two or
more
columns in a
defined range. I want to have a dropdown validation
list
where two or more
columns of data is displayed on the dropdown list. When
an item is selected
in the dropdown list only one of the columns data is
displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down
please let me know.

Thanks
Pat


.

.

It is unclear if you are saying this is what you want, or you are
complaining that this is what happens and not what you want. It certainly
is what happens and there is no way around that unless you use code to
interpret the selection and write a concatenated string of the column
values
to the single cell or write the row in the combobox dropdown across
multiple
cells

Yes this what I want and I am happy with that.

Do you happen to know if there is examples of what you suggest on the web?


"Tom Ogilvy" wrote in message
...
You can have a defined range with two or more columns, but that won't show
up in Data=Validation using the list option. You might want to look at
the
Control Toolbox Toolbar Combobox or Listbox.

When an item is selected
in the dropdown list only one of the columns data is displayed in the
cell.

It is unclear if you are saying this is what you want, or you are
complaining that this is what happens and not what you want. It certainly
is what happens and there is no way around that unless you use code to
interpret the selection and write a concatenated string of the column
values
to the single cell or write the row in the combobox dropdown across
multiple
cells.

--
Regards,
Tom Ogilvy


"Pat" wrote in message
...
Can anyone tell me if it is possible to have two or more columns in a
defined range. I want to have a dropdown validation list where two or
more
columns of data is displayed on the dropdown list. When an item is
selected
in the dropdown list only one of the columns data is displayed in the
cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down please let me know.

Thanks
Pat

I have tried you suggestion and was unsuccessful only a date 00-01-1900 was
returned from the formula. Am I missing something here?


"Jason Morin" wrote in message
...
Try SUMIF. For example, let's say your dates are in col.
A, values to sum in col. B, and all this is in a sheet
named "mysheet". With a date in A1 of a new sheet, use:

=SUMIF(mysheet!A:A,A1,mysheet!B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can anyone tell me if it is possible to have two or more
columns in a
defined range. I want to have a dropdown validation list
where two or more
columns of data is displayed on the dropdown list. When
an item is selected
in the dropdown list only one of the columns data is
displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down
please let me know.

Thanks
Pat


.