Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default vlookup

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