![]() The lookup value in most cases should be a relative reference (like E2) or you can lock only the column coordinate ($E2). When using VLOOKUP formulas in real-life worksheets, the main rule of thumb is this: lock table array with absolute cell references (like $A$2:$C$11) to prevent it from changing when copying a formula to other cells. With all the arguments established, you should have no problem reading the whole formula: search for "lion" in A2:A11, find an exact match, and return a value from column B in the same row.įor the sake of convenience, you can type the value of interest in some cell, say E1, replace the "hardcoded" text with the cell reference, and get the formula to look up any value you input in E1:ĭoes anything remain unclear? Then try looking at it this way: The 4 th argument range_lookup is FALSE, which indicates that we are looking for exact match.Meaning, we want to return a matching value from column B, which is second in the table array. Keeping in mind that the search is performed in the left-most column, you can read the above formula a little further: search for "lion" in the range A2:A11. ![]() The 2 nd argument ( table_array) is A2:B11. ![]()
0 Comments
Leave a Reply. |