Rounding values in a VLOOKUP function

Hello all.

In the spreadsheet below I am using the values from the table and an inputted value (yellow box) inside the formula =VLOOKUP(B16,F15:G29,2,TRUE) to find the correct emulation batch.

B16 is the value i have entered (yellow box) and is the one I am using to look up.  F15:G29 are the values in the box.  2 shows that I want the value in the 2nd column, and TRUE that it is an approximate match (FALSE would be an exact match).  I have to use the approximate match because i am measuring mean particle size – so chances are very slim of getting one exactly to the same.

It works well except the result I get is always rounded down, as opposed to rounding to the closest value.  Hence, for some values I get the wrong batch suggestion (as with the example values below).  I would’ve thought because it is an approximate match that the closest value is used.  Is there anyway around this? I have tried entering a ROUND in various places but this hasn’t helped, as of yet.

Thanks very much in advance.

Parameter Value Emulation batch:
d(0.5) 96.49 FA1033
Table 1
d(0.5) average Batch
92.351 FA1111
92.4728 FA1114
92.4975 FA1116
92.8868 FA1112
92.8901 FA1113
93.2075 FA1115
93.4474 FA1075
94.6016 FA1067
94.6501 FA1099
94.7286 FA1057
95.4176 FA1053
95.5923 FA1051
95.68 FA1107
96.3676 FA1033
96.5075 FA1022

2,732 thoughts on “Rounding values in a VLOOKUP function

  1. Agen Poker Terpercaya

    Hi there, just turned into aware of your weblog thru Google, and located that it is really informative. I am going to watch out for brussels. I’ll be grateful when you proceed this in future. Numerous other folks shall be benefited from your writing. Cheers!|

  2. Shaneka Chautin

    Oh my goodness! an incredible article dude. Thank you However I’m experiencing situation with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting identical rss downside? Anyone who is aware of kindly respond. Thnkx

  3. casino sbobet

    Hi there, simply become alert to your weblog through Google, and found that it’s really informative. I’m gonna be careful for brussels. I will be grateful when you proceed this in future. Numerous people will probably be benefited out of your writing. Cheers!|

  4. sbobet online

    What i don’t realize is in reality how you’re not really much more smartly-favored than you may be now. You are very intelligent. You recognize thus significantly in relation to this matter, produced me individually imagine it from numerous numerous angles. Its like men and women aren’t interested until it is one thing to accomplish with Woman gaga! Your individual stuffs nice. All the time take care of it up!|

  5. click here

    Wow, superb blog structure! How lengthy have you been blogging for? you make running a blog glance easy. The full glance of your web site is great, let alone the content!


    Thank you for another excellent post. The place else could anyone get that type of info in such an ideal method of writing? I have a presentation subsequent week, and I am at the search for such info.

  7. Fake

    I’m really inspired with your writing skills as well as with the layout to your weblog. Is that this a paid subject matter or did you modify it yourself? Anyway stay up the nice high quality writing, it is rare to look a great weblog like this one today..|

Comments are closed.