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.