Vlookup #REF error

[vba317]

I am having a problem with my Vlookup formula I am hoping that I can get some help. The formula is on Sheet1 cell Y15. I am trying to do a lookup based on account number on sheet 1 and 2. on Sheet 1 the account number is in Column C the column header is C11. On sheet 2 the account # column is column B. In Cell Y15 on sheet 1 I want the address field from sheet 2 Column H when the account numbers match.
Any help is appreciated.

=VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)

 

[63falcondude]

Vlookup should be of the form =VLOOKUP(lookup value, table array, column index number (should be a number),FALSE)

 

[vba317]

Vlookup should be of the form =VLOOKUP(lookup value, table array, column index number (should be a number),FALSE)

I tried this and I get a #NA error
=VLOOKUP(Sheet1!C15,Sheet2!A:H,3,FALSE)

 

[Aladin Akyurek]

I tried this and I get a #NA error
=VLOOKUP(Sheet1!C15,Sheet2!A:H,3,FALSE)

This formula says: Look up C15 of Sheet1 in column A of Sheet2. If found, return the corresponding value from column C of Sheet2. Is this what you are after?

 

[Jonmo1]

Looking at your original attempted formula

=VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)

It would seem you want
=VLOOKUP(C11,Sheet1!C:H,6,FALSE)

 

[63falcondude]

Looking at your original attempted formula


It would seem you want
=VLOOKUP(C11,Sheet1!C:H,6,FALSE)

This is what I thought at first until I noticed the different sheets in his attempted formula.

=VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)

 

[Jonmo1]

This is what I thought at first until I noticed the different sheets in his attempted formula.
=VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)

I didn't even notice that.

I think the lookup range should be sheet2 then

Looking at your original attempted formula


It would seem you want
=VLOOKUP(C11,Sheet1!C:H,6,FALSE)

That should be
=VLOOKUP(C11,Sheet2!C:H,6,FALSE)