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.

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!
================================================== ===

"Johosh" wrote in message
...
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.

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Johosh" wrote in message
...
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.

Thanks so much! That was EXACTLY what I needed!

"RagDyeR" wrote:

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!
================================================== ===

"Johosh" wrote in message
...
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.

Thanks so much! That was EXACTLY what I needed!

"T. Valko" wrote:

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Johosh" wrote in message
...
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.

Appreciate the feed-back.
--

Regards,

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

"Johosh" wrote in message
...
Thanks so much! That was EXACTLY what I needed!

"RagDyeR" wrote:

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!
================================================== ===

"Johosh" wrote in message
...
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.