Sep 19 2022 11:37 AM
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 |
Sep 19 2022 12:01 PM - edited Sep 19 2022 12:02 PM
SolutionSep 19 2022 12:01 PM - edited Sep 19 2022 12:02 PM
SolutionYou omitted the column index. Try this:
=VLOOKUP(J4,HCAPS!$A$3:$B$24,2,FALSE)