Forum Discussion
VLOOKUP #N/A error -- first time poster
Does this work?
=VLOOKUP(ROUND(B19, 2), Supplemental!$H$17:$I$1017, 2, FALSE)
It does! Thank you! I just looked up the Round function. If I'm understanding correctly, it seems that even though I changed the decimal spaces in the cell (using the Decrease/Increase Decimal tool in the Number section of the Home menu, that only changes what I see in the table, not the actual value in the cell. The ROUND function actually changes the value so it goes out to 2 decimal spaces to match the z-scores I'm "looking up."
Yes, that is correct. A number format only governs what you see on the screen, not the underlying value (*). The ROUND function modifies the value returned by the formula.
(*) There is an exception: if you select the check box "Set precision as displayed" in File > Options > Advanced > When calculating this workbook, then Excel will round all values as they are displayed on the screen.