VLOOKUP - Strange results

Originally Posted by paulwelburn

The following code is used to calculate a golf handicap based upon the category it falls in on the table (see file). For some reason the calculation works perfect for the code in cell C5 but when filled across the row to retrieve the same calculation I don't get the correct results!

Please Login or Register  to view this content.

As the Net Handicap Score in C14 is -1 the correct result in D5 should be 23.60 - 0.4 giving 23.20 for the exact handicap score, why is this?

Hi,

not sure why you would post a .pdf, it gives helpers no chance to review your formula.

The answer you display does not appear to be the same as my result.

hth
---

Hi Bryan
The coding from your file is exactly the same coding i'm using, I can't understand why the results differ. I've attached the file i'm working on. Maybe there's something i've missed! Sooooo frustrating. Thanks in advance.

Originally Posted by paulwelburn

Hi Bryan
The coding from your file is exactly the same coding i'm using, I can't understand why the results differ. I've attached the file i'm working on. Maybe there's something i've missed! Sooooo frustrating. Thanks in advance.

C14 is -.60 - not (as displayed) -1

---

Originally Posted by paulwelburn

Apologies. Got it now. I rounded the numbers using the toolbar decimal place button as opposed to the function Round. You won't believe what frustration this simple oversight caused!! Thank you very much

Good to see it works for you, and why the .pdf is not of much use. Thanks for your response.
---