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...