Vlookup question

[bionicle]

hi all,

can some one explain how I achieve this please.

I've tried several things without success.


In the function agreement I have the following:

Lookup value $K9 = 0
Table Array SFG ={1,2,3,4,5,6,7,8,9,10…..
Col index num 12 = 12
Range lookup 0 = False
=0


I’ve tried to repeat this but the table array just has thefollowing:
‘SFG+'Codes SFG'!B5:F50

any help would be great

 

[CharlesChuckieCharles]

Hi

You best move is to post your code rather than describe it

also have you done the lookup as a formula in a sheet just to check that its logically correct