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