Is that an I as in "eye" or an L as in "ell"?

If an "eye" then you have less than 10 columns in your lookup table so your
column index of 10 is out of range.


Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 11:05:02 -0700, Jim
wrote:

Hello,

I am using the following vlookup formula: =VLOOKUP(A2,SF_Input!A:I,10,FALSE)

however i am receiving an error: #REF!

I have also tried the following: =VLOOKUP(A2,SF_Input!A$1:I$100,10,FALSE)

I have double checked the fields and everything looks okay to me.

Thoughts? Is hte formula correct?

Thanks