View Single Post
  #1   Report Post  
Snorkster
 
Posts: n/a
Default =(A6)!$O$14 - why won't this look for same name sheet as A6?

i want to be able to look for a worksheet that matches a name in a given cell?

Examlpe - the text in cell A6 is master, so i want to look for the sheet
called master so that i can look for specific cells in that sheet. This is so
that i can use multiple sheets for a work training matrix?