Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a "data-source". What I have is a sheet that contains inventory, which I would like to reference on another page (in the same wb, or not; I don't care) by simply typing in the number that designates the inventory.
Example: Data-source page is set up like this

A B
1000 Ceramic Tile $4,000.0
2000 Hardwood Floor $7,000.0

How do I create another page, using the numbers in column A, to reference the data stored in column B & C? I want to be able to type in "1000" and have column's B & C prefill with the information on the data-source sheet. Can anyone help?
 
Heather,

If you have the Inventory on Sheet2 in a range of A1.C1000
and if the number you want to look up is in Sheet1 cell A1
then in sheet1 B1 enter:
=VLOOKUP($A1,Sheet2!$A$1:$C$1000,2,FALSE)
and in sheet1 C1 enter:
=VLOOKUP($A1,Sheet2!$A$1:$C$1000,3,FALSE)
Copy the B1 and C1 down as needed.

Charlie O'Neill
-----Original Message-----
I am trying to create a "data-source". What I have is a
Click to expand...
sheet that contains inventory, which I would like to
reference on another page (in the same wb, or not; I don't
care) by simply typing in the number that designates the
inventory.
Example: Data-source page is set up like this:

A B C
1000 Ceramic Tile $4,000.00
2000 Hardwood Floor $7,000.00

How do I create another page, using the numbers in column
Click to expand...
A, to reference the data stored in column B & C? I want to
be able to type in "1000" and have column's B & C prefill
with the information on the data-source sheet. Can anyone
help?
 
Back
Top