List Selection


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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top