vlookup sporadic errors

[DGcincy]

Hi,

I'm attempting to use vlookup of create a table of values from an array. Unfortunately it seems to give me sporadic success/failure.

Here's the formula I am using:

=VLOOKUP('001-052'!N2,'001-052'!B16:H29,3,FALSE)

below in the first image you can see the errors its outputting and then in the second image is the sheet the formula is directed towards, with the lookup ids in red on the upper right corner.

thoughts please?

Drew

 

[jarjarbingie]

well, I am unable to see the images you posted but the only thing I'm seeing wrong in the formula is the lookup table is not absolute or was not locked so to speak..

it should be:
=VLOOKUP('001-052'!N2,'001-052'!$B1$6:$H$29,3,FALSE)

press F4 once you've put in the lookup table which is the 2nd parameter in the formula