I need help writing a formula that will list the values of B3:B53 for which
A3:A53 is equal to a specifiic value.
A3:A53 are set up with dropdown menus to select from a list of values (in
this case locations) and I need to have a cell which lists the values in B
for each item in the list.
Is there a way to do this without creating a mile long if statement?

This is easily accomplished by creating a simple 2 column datalist in an
out-of-the-way location, with the locations in the first column and the
pertinent values in the next column.

Say you enter the locations in Y1 to Y25,
And the accompanying data in Z1 to Z25.

Then try something like this in B3:

=Vlookup(A3,Y$1:Z$25,2,0)

And copy down as needed.

If you're annoyed by the #N/A errors when Column A may be empty, you can try
this formula:

=If(ISNA(Match(A3,Y$1:Y$25,0)),"",Vlookup(A3,Y$1:Z $25,2,0))

--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------


"Debbiejj" wrote in message
...
I need help writing a formula that will list the values of B3:B53 for which
A3:A53 is equal to a specifiic value.
A3:A53 are set up with dropdown menus to select from a list of values (in
this case locations) and I need to have a cell which lists the values in B
for each item in the list.
Is there a way to do this without creating a mile long if statement?

Thank you very much. This will do it.

"RAGdyer" wrote:

This is easily accomplished by creating a simple 2 column datalist in an
out-of-the-way location, with the locations in the first column and the
pertinent values in the next column.

Say you enter the locations in Y1 to Y25,
And the accompanying data in Z1 to Z25.

Then try something like this in B3:

=Vlookup(A3,Y$1:Z$25,2,0)

And copy down as needed.

If you're annoyed by the #N/A errors when Column A may be empty, you can try
this formula:

=If(ISNA(Match(A3,Y$1:Y$25,0)),"",Vlookup(A3,Y$1:Z $25,2,0))

--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------


"Debbiejj" wrote in message
...
I need help writing a formula that will list the values of B3:B53 for which
A3:A53 is equal to a specifiic value.
A3:A53 are set up with dropdown menus to select from a list of values (in
this case locations) and I need to have a cell which lists the values in B
for each item in the list.
Is there a way to do this without creating a mile long if statement?

Appreciate the feed-back.
--
Regards,

RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------

"Debbiejj" wrote in message
...
Thank you very much. This will do it.

"RAGdyer" wrote:

This is easily accomplished by creating a simple 2 column datalist in an
out-of-the-way location, with the locations in the first column and the
pertinent values in the next column.

Say you enter the locations in Y1 to Y25,
And the accompanying data in Z1 to Z25.

Then try something like this in B3:

=Vlookup(A3,Y$1:Z$25,2,0)

And copy down as needed.

If you're annoyed by the #N/A errors when Column A may be empty, you can
try
this formula:

=If(ISNA(Match(A3,Y$1:Y$25,0)),"",Vlookup(A3,Y$1:Z $25,2,0))

--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------


"Debbiejj" wrote in message
...
I need help writing a formula that will list the values of B3:B53 for
which
A3:A53 is equal to a specifiic value.
A3:A53 are set up with dropdown menus to select from a list of values
(in
this case locations) and I need to have a cell which lists the values
in B
for each item in the list.
Is there a way to do this without creating a mile long if statement?