Index function question

confuse

New Member
Joined
Dec 29, 2005
Messages
1
How do I change this formula if the data I need to access is in Sheet2, same column and rows number.Thank you very much for any help.

=(INDEX($B$5:$H$211,MATCH(CM12,$A$5:$A$211),MATCH($CQ$7,$B$3:$H$3,0))-INDEX($B$5:$H$211,MATCH(CM12,$A$5:$A$211)+1,MATCH($CQ$7,$B$3:$H$3,0)))/(INDEX($A$5:$A$211,MATCH(CM12,$A$5:$A$211))-INDEX($A$5:$A$211,MATCH(CM12,$A$5:$A$211)+1))*(CM12-INDEX($A$5:$A$211,MATCH(CM12,$A$5:$A$211)))+INDEX($B$5:$H$211,MATCH(CM12,$A$5:$A$211),MATCH($CQ$7,$B$3:$H$3,0))
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
670
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Hi Confuse , Welcome To The Board,

Pressuming that the date you will be changing is
located in sheet two , lets say cell A1.

Why not enter =Sheet2!A1 into cell A1 on sheet one ?

HTH

Russ
 

Watch MrExcel Video

Forum statistics

Threads
1,118,455
Messages
5,572,235
Members
412,449
Latest member
mdvouf
Top