Vlookup function - how to round up?

N

Natalie

I'm trying to lookup a number that has a really long decimal figure:
eg: 2.33334444555666777

Is there anyway I can search for it by just typing "2.3333" instead of
the whole long number?

-Nat
 
D

Dave Peterson

See your other post.
I'm trying to lookup a number that has a really long decimal figure:
eg: 2.33334444555666777

Is there anyway I can search for it by just typing "2.3333" instead of
the whole long number?

-Nat
Click to expand...
 
M

mr_ben

use the round function...

=round(-vlookup formula-,3)


that would round the result to 3 (replace the 3 to another number to
round to that amount....
 
Top