We need to sort the first column in ascending order. So, let's use the Approximate Match to find the solution. Also, we know this value is not present in the table. In the example below, we use the VLOOKUP function to find out how much RAM specification a laptop priced 1300 EUR has. How To Find Approximate Match Using VLOOKUP?Īpproximate Match works by finding the next largest value that is lesser than the lookup value, which we specify. With the help of VLOOKUP in Excel, we can look for an approximate match as well. An N/A error is displayed in case the exact value is not found. Here, the value is set to FALSE for the VLOOKUP function to return an exact match for the value.
0 Comments
Leave a Reply. |