Updated: May 2, 2019
This function looks for a piece of information in a list of values, and then picks an item from the last cell in the adjacent row or column.
It always picks the data from the end of the row or column. If you would like to pick any particular value in the middle of the table, then you have to use either Vlookup or Hlookup
If the table has more rows than columns or if the rows & column are equal in number:
the function will look down the left most column trying to find a match for the piece of information you asked it to look for.When a match is found, the function will look across to the right most column to pick the last entry on the row.
If the table has more Columns than rows:
the function will look across the top row trying to find a match for the piece of information you have asked it to look for.When a match is found, the function will then look down to the bottom cell of the column to pick the last entry of the column.
Here is the video tutorial of the same for clear understanding.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at firstname.lastname@example.org