SOLVED

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

New Contributor

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
151
161
171
181
191

 

 

1 Reply
best response confirmed by ianshaw2 (New Contributor)
Solution

@ianshaw2 

You omitted the column index. Try this:

 

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