# 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.

 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!|