View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Old Guy Old Guy is offline
external usenet poster
 
Posts: 5
Default 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?