![]() The 2 nd argument ( table_array) is A2:B11.The 1 st argument ( lookup_value) clearly indicates that the formula looks up the word "lion".Please have a look at the below formula and try to "translate" it into English: ![]() Here is an example of the Excel VLOOKUP formula in its simplest form. If an exact match is not found, a #N/A value is returned. The formula searches for a value exactly equal to the lookup value. Requires sorting the lookup column in ascending order. If an exact match is not found, the formula searches for the largest value that is smaller than the lookup value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |