![]() This formula provides two types of matched value i.e.It can only look up the value from the Selected cell(Table_array) from left to right side. So, we do not need to find the values individually from the selected date and then copy, paste it. it will show the matched value in the column/row where you want.It helps in saving time and doing work more efficiently.With the help of VLOOKUP, we can retrieve the numbers of exact or approximate matched value in the seconds.The lookup value must be in the first column in the selected cells(table array). It can only look up and retrieve the values in the vertical order. It supports approximate and exact matched value. ![]() In VLOOKUP, V stands for vertical and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from left to right means in vertical order.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |