You're right I was only referencing 9 columns.

Thanks


"cm" wrote:

Jim,

couple of things -- your 'database' columns A thru I -- be sure the sheet
name is spelled correctly (SF_Input) also you probably don't need the $
absolute references there. However, I think your issue is that your are
selecting column 10 to find the value in, and there are only 9 columns in A
thru I.
--
hope to help,
cm


"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