INDEX & MATCH FUNCTION

 INDEX & MATCH FUNCTION

MATCH FUNCTION IS USED TO GETTING THE RELATIVE POSITION (RETURNS ONE VALUE EXAMPLE:-1/2/3 ETC...) IS A PARTICULAR CELL RANGE.

INDEX FUNCTION IS USED TO GET THE VALUE OF A SPECIFIC CELL RANGE WITH SPECIFIC ROW AND SPECIFIC COLUM VALUE WITH RESPECT TO SPECIFIED ROW.

THIS TWO FUNCTION CAN BE USED COMBINED TO SUBSTITUE THE VLOOKUP FUNCTION.IN THE VLOOKUP FUNCTION.

WE ARE GETTING THE VALUES OF A CELL VALUE ON/AFTER THE SERACH VALUE TO WARDS RIGHT DIRECTION BUT WITH.

THE INDEX AND MATCH FUNCTION WE CAN GET THE VALUES FROM RIGHT TO LEFT IN ALL DIRECTION I.E. FROM THE LEFT TO RIGHT OF THE SERACH VALUE IN A CELL OR RIGHT TO LEFT OF THE SEARCH VALUE IN A CELL.

HERE ALSO WE CAN GET ONE SEARCH VALUE WITH RESPECT TO THE SEARCH CELL VALUE WE CANNOT GET THE LIST OF VALUES.

On the previous blogs vlookup defination is explained.Please click on this link to read that blog.

Click Here.Thankx for reading.