T
Tim Hagedorn
I would like to use a formula, or macro, that would look
at one cell and fill in based on a table that I have set
up.
Example:
My Table would look like this
A B
Red Ball 1.50
Pink Ball 1.00
Blue Ball 0.75
I then have a second sheet that has the following data.
This is a sheet that I will print off for reports. I
want column "C" below to fill from column "B" above,
based on what column "A" below has typed in that cell.
A B C D
Product Quantity Price Total
Blue Ball 5 0.75 3.75
Pink Ball 10 1.00 10.00
Totals 15 1.75 13.75
I know I can use the "IF" function for this simple one,
but I will have 100's of different "Products" that will
be on my first table.
Thank you.
at one cell and fill in based on a table that I have set
up.
Example:
My Table would look like this
A B
Red Ball 1.50
Pink Ball 1.00
Blue Ball 0.75
I then have a second sheet that has the following data.
This is a sheet that I will print off for reports. I
want column "C" below to fill from column "B" above,
based on what column "A" below has typed in that cell.
A B C D
Product Quantity Price Total
Blue Ball 5 0.75 3.75
Pink Ball 10 1.00 10.00
Totals 15 1.75 13.75
I know I can use the "IF" function for this simple one,
but I will have 100's of different "Products" that will
be on my first table.
Thank you.