GOOGLE LOOK UP HOW TO
The image below shows you some examples of how to use LOOKUP function on rows. OK, so that was an example for the columns. This is where this formula falls short, and you need to rely upon VLOOKUP and HLOOKUP for exact matching capabilities. Unlike those functions, LOOKUP function does not have an option for approximate vs. This may not always make practical sense, and you might need an exact match. In this scenario, the formula hooks onto the nearest and smallest value for a match. Sometimes you might find that the lookup value does not match any of the values in the lookup column or row (the last example in the screenshot above). For the LOOKUP formula to function as expected, you need the lookup column to be sorted in ascending order. While the formula itself has returned a value, it’s incorrect. You’ll notice that the Salary column is not sorted. What if they are not? How does LOOKUP formula behave in this instance? One underlying assumption in all of the examples, from rows 2 through to 6, is that the columns are sorted in ascending order. If you need to fetch results from a column or row in the middle of the range, you may have to use the VLOOKUP or HLOOKUP formulas. You can see this in the examples in rows 3 and 6.
You will also see that for the search_result_array option, the results come from the last row or column in the range.
Take a look at rows 4 and 5 to see examples of this. It’s worth noting that LOOKUP formula, unlike VLOOKUP and HLOOKUP formulas, can return values before the lookup column.