How to use index function to match from different worksheets?

Closed
Report
-

hi there,

please let me know how can i use index match from different worksheets. as i need to use index function for more than one worksheets. i know it is possible with vlookup, is it possible with index and match function