Thread: INDIRECT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Newbie
 
Posts: n/a
Default INDIRECT

I have the following formula which works fine:

=INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",February!4:4,0))

I would like February to be the variable contents of a particular cell but
cant get my referencing right. Can anyone please help??