Report

Can the index function in Excel set a range in different sheet?

Ask a question abhininan 1Posts Tuesday November 7, 2017Registration date November 9, 2017 Last seen
Hello there,

I need a small help. I need to know whether we can use the index function for setting a range in different sheets.


I've used an example Please help me in this...

=INDEX(Sheet1:Sheet2!A1:A18,MATCH("RAJIN",Sheet1:Sheet2!B1:B18,0))

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!