Main Profile

At A Glance

Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how to:1. See how to avoid the default VLOOKUP behavior and instead find a value in the first column of the lookup table that is closest to the lookup Value.2. Because the increment between the values in the first column of the lookup table are the same, we can round to the nearest 0.25 using MROUND or ROUND functions and force the VLOOKUP to find the nearest value instead of the default behavior" between two values"3. See how to use MROUND function to round the lookup value so you can find the nearest value in the first column of the lookup column4. See how to use ROUND function to round the lookup value so you can find the nearest value in the first column of the lookup columnLookup that rounds to the nearest number
Length: 03:10

Contact

Questions about Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)

Want more info about Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question