Forum Discussion
ianshaw2
Sep 19, 2022Copper Contributor
vlookup problem =VLOOKUP(J4,HCAPS!$A$3:$B$24,FALSE)
Hi Team
the above returns a value not the result I cannot find out what is going wrong any thoughts very much appreciated, hcaps sheet is below (or part thereof)
| Score | adjust |
| 15 | 1 |
| 16 | 1 |
| 17 | 1 |
| 18 | 1 |
| 19 | 1 |