View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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?