Link to another worksheet

  • Thread starter Thread starter Old Guy
  • Start date Start date
O

Old Guy

I have 90 sheet with catalog numbers and pricing. I want to have a main sheet
to enter the catalog number and then in the cell next to it return the cost.
=??? (Sheet1!) ?????????? .is there a simple formula that will
automaticly return the cost when I put the catalog number into the cell?
 
Hi,
If you know the sheet name from where you want to pull the information use
in let's say cell C3


=+VLOOKUP(B3,Sheet2!$A:$B,2,FALSE)

Where B3 is where you enter the catalog #, Sheet2 where you have your
catalog, column A where you have the catalog # and column B the cost,
If you are not using excel 2007 use

=+VLOOKUP(B3,Sheet2!$A$1:$B$1000,2,FALSE)
 
I'm not very good with how formulas work and I don't think I am doing it right.
(main is sheet one) Sheet2 in cell A2 is catalog number, in cell B2 is the
cost.
This formula should work, right?
 
Hi,
The formula is looking at the whole column in sheet2 so in my example you
have entered the catalog number in Sheet 1 cell B3, if your information is in
cell A3 change the formula from B3 to A3
 
Thank you again, I'll give it a try.

Eduardo said:
Hi,
The formula is looking at the whole column in sheet2 so in my example you
have entered the catalog number in Sheet 1 cell B3, if your information is in
cell A3 change the formula from B3 to A3
Click to expand...
 
Back
Top