IF statement pulling from Product List


G

Guest

I'm trying to setup a simple tracking system with a product list. What I want
to do is have one sheet list all the product information (item name, number,
cost, etc), and have another that tracks each customer's order.

I want to input the product number on the customers order, and have the rest
of the fields (cost, etc) update automatically.

The problem is the list I'm using is too long to have that many IF statements.

Can you have a formula look for a specific item number from a range?

Example of Theory in cell B1:
=if(a1=f1:f10,g1:g10,"-")
If a1 is equal to one of the cells in the f1-f10 range, then b1 will equal
the corresponding G cell in that row.
 
Ad

Advertisements

R

RagDyeR

It sounds as though you should use a datalist and the Vlookup function.

Check out this link of Debra Dalgleish:

http://www.contextures.com/xlFunctions02.html

--

HTH,

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

I'm trying to setup a simple tracking system with a product list. What I
want
to do is have one sheet list all the product information (item name, number,
cost, etc), and have another that tracks each customer's order.

I want to input the product number on the customers order, and have the rest
of the fields (cost, etc) update automatically.

The problem is the list I'm using is too long to have that many IF
statements.

Can you have a formula look for a specific item number from a range?

Example of Theory in cell B1:
=if(a1=f1:f10,g1:g10,"-")
If a1 is equal to one of the cells in the f1-f10 range, then b1 will equal
the corresponding G cell in that row.
 
Ad

Advertisements

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