I would like to write a macro that populates rows with different text
whose value depends upon one cell value.

For example if cell A1 = "163", then cell B1 = "BLUE' AND cell C1 =
"$2.95" AND cell D1 = "tennis ball"

Thanks for any feed back!!

Amanda,

Have you looked at using the VLOOKUP function? If your data (i.e. the id
number, color, price, and type) is in a table, then simply use VLOOKUP. So,
you would have a VLOOKUP function in cells B1, C1, and D1. The lookup value
would reference A1, the table array would be wherever your table data is
located, the column index would correspond to the appropriate table column of
the data you want returned (where column 1 has the same type of data as in
cell A1, i.e. the id number), and the range lookup is TRUE for a close match
and FALSE for an exact match.

Best,

Matthew Herbert

"amanda" wrote:

> I would like to write a macro that populates rows with different text
> whose value depends upon one cell value.
>
> For example if cell A1 = "163", then cell B1 = "BLUE' AND cell C1 =
> "$2.95" AND cell D1 = "tennis ball"
>
> Thanks for any feed back!!
> .
>

Do you specifically need a macro?

VLOOKUP worksheet function would do as well.


Gord Dibben MS Excel MVP

On Wed, 11 Nov 2009 12:16:52 -0800 (PST), amanda <(E-Mail Removed)>
wrote:

>I would like to write a macro that populates rows with different text
>whose value depends upon one cell value.
>
>For example if cell A1 = "163", then cell B1 = "BLUE' AND cell C1 =
>"$2.95" AND cell D1 = "tennis ball"
>
>Thanks for any feed back!!

On Nov 11, 3:08*pm, Matthew Herbert
<MatthewHerb...@discussions.microsoft.com> wrote:
> Amanda,
>
> Have you looked at using the VLOOKUP function? *If your data (i.e. the id
> number, color, price, and type) is in a table, then simply use VLOOKUP. *So,
> you would have a VLOOKUP function in cells B1, C1, and D1. *The lookup value
> would reference A1, the table array would be wherever your table data is
> located, the column index would correspond to the appropriate table column of
> the data you want returned (where column 1 has the same type of data as in
> cell A1, i.e. the id number), and the range lookup is TRUE for a close match
> and FALSE for an exact match.
>
> Best,
>
> Matthew Herbert
>
>
>
> "amanda" wrote:
> > I would like to write a macro that populates rows with different text
> > whose value depends upon one cell value.
>
> > For example if cell A1 = "163", *then cell B1 = "BLUE' AND cell C1 =
> > "$2.95" AND cell D1 = "tennis ball"
>
> > Thanks for any feed back!!
> > .- Hide quoted text -
>
> - Show quoted text -

Hi Matthew. This worked great. Thank you very much for your help!!