Thread: Which function to use?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Which function to use?
In Sheet2, put the number in A1 and in B1 put:

=INDIRECT("Sheet1!A" & A1)
--
Gary''s Student - gsnu200781
Reply With QuoteReply With Quote