Forum Discussion

ianshaw2's avatar
ianshaw2
Copper Contributor
Sep 19, 2022
Solved

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 ...
  • HansVogelaar's avatar
    Sep 19, 2022

    ianshaw2 

    You omitted the column index. Try this:

     

    =VLOOKUP(J4,HCAPS!$A$3:$B$24,2,FALSE)

Resources