Replace OFFSET with INDEX

[dcantere]

I am sorry for my english. Hope friends can help me. I use a formula within the data validation. =OFFSET(DATA!$C$1,MATCH(C2,DATA!$C$2:$C$3500,0),8;COUNTIF(DATA!$C$2:$C$3500,C2)). I know that the shift function makes it impossible to use it in another workbook, but would it be possible to replace the formula I'm using with index? So I could use it by searching in another workbook. I hope you understood my question and that someone can help me? I appreciate the help. tks

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Replace OFFSET with INDEX
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.