Link to another worksheet

[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?

 

[Eduardo]

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)

 

[Old Guy]

Thank you, very much for the information, Eduardo. This helps a lot.

 

[Old Guy]

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?

 

[Eduardo]

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

 

[Old Guy]

Thank you again, I'll give it a try.

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