Link to another worksheet
 

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?

Link to another worksheet
 

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" wrote:

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?

Link to another worksheet
 

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

"Eduardo" wrote:

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" wrote:

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?

Link to another worksheet
 

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?

"Old Guy" wrote:

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

"Eduardo" wrote:

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" wrote:

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?

Link to another worksheet
 

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" wrote:

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?

"Old Guy" wrote:

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

"Eduardo" wrote:

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" wrote:

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?

Link to another worksheet
 

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

"Eduardo" wrote:

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" wrote:

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?

"Old Guy" wrote:

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

"Eduardo" wrote:

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" wrote:

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?