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

[Closed]
Report
Posts
1
Registration date
Tuesday November 7, 2017
Status
Member
Last seen
November 9, 2017
-
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))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!