View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kashyap Kashyap is offline
external usenet poster
 
Posts: 131
Default Indirect with index and match

Hi, I have the below formula where it flech data from sheet as per C5.. In
this case it is 'PRX'..

=INDEX(PRX!G1:G100,MATCH(1,(C7=PRX!C1:C100)*(F7=PR X!D1:D100)*(J9=PRX!E1:E100)*(C12=PRX!F1:F100),0))

How can I use indirect ref to sheet with this formula?