Dear All,
I have read that the Index and Match function is one of the most useful function in Excel. I have tried to learn about Index and match function in web a lot but i did not understand that as it is a wonderful function in excel.
I know well lookup functions and uses for comparing data, finding missing data etc..
Could you please give some common usage of index match which I can use in my works and also please explain me what index match do better than Vlookups..
Thanks,
Yasir
I have read that the Index and Match function is one of the most useful function in Excel. I have tried to learn about Index and match function in web a lot but i did not understand that as it is a wonderful function in excel.
I know well lookup functions and uses for comparing data, finding missing data etc..
Could you please give some common usage of index match which I can use in my works and also please explain me what index match do better than Vlookups..
Thanks,
Yasir