SOLVED

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

Copper 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 (Copper Contributor)
Solution

@ianshaw2 

You omitted the column index. Try this:

 

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

1 best response

Accepted Solutions
best response confirmed by ianshaw2 (Copper Contributor)
Solution

@ianshaw2 

You omitted the column index. Try this:

 

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

View solution in original post