Incorrect Vlookup syntax

[lordterrin]

Another vlookup thread on the forums.... sorry!

I have the following vlookup that is not working, and I can't figure out why.

Please Login or Register  to view this content.

So - the code is working fine, apart from the vlookup line. Here is what I'm trying to do:

My FOR statement is in column C. Here is a breakdown of what I am trying to get the code to do:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

When I execute the code, I just get a blank cell in column S. There's no data there - so the formula is not executing correctly, but I can't figure out where the error is happening.

[Izandol]

I do not think formula is correct - you may try:

Please Login or Register  to view this content.

[lordterrin]

Hmm... nope - still doesn't work. I'm wondering if there's an issue with the RC-15 or the C1:C2 that I'm using.... Is my syntax correct for the cells I'm trying to reference?

[bulina2k]

you said :

'look at column D of this sheet: 15 rows BACK from column S

rows!!! not columns! carefull!
so what's with the Data!C1:C2 ?

have you tried

Please Login or Register  to view this content.

[Izandol]

If you comment out .Value = .Value line, what formula is put in cell?

[lordterrin]

Data!C1:C2 is the first part of the vlookup - it defines which sheet I'm looking on, (Data), and the C1:C2 says look in column 1 to column 2 - find a match in the second column (,2), and False (,0)

But yes - I did mean "15 COLUMNS back from column s"

Your suggestion does not work as it's missing integral vlookup data.

[lordterrin]

If you comment out .Value = .Value line, what formula is put in cell?

Nothing. It's blank.

and just a side note - InfBranchList is pointing to the correct file, the sheet's name IS Data, and the data is in columns 1 and 2.

[Izandol]

What is value of lastrow and is there on error resume next statement somewhere?

.......... 'code that I don't need to show here.........

Perhaps this code must be shown.