VLookup is choosing values from other lines

[josorens]

Worksheets("Tables and Calcs").Cells(i + 126, 11).Value = Application.VLookup("MBH", Worksheets("Tables and Calcs").Range("B117:DY120"), Application.Match(Worksheets("Tables and Calcs").Cells(i + 126, 4), Worksheets("Tables and Calcs").Range("B117:DY117"), 0))

Worksheets("Tables and Calcs").Cells(i + 126, 13).Value = Application.VLookup("GPM", Worksheets("Tables and Calcs").Range("B117:DY120"), Application.Match(Worksheets("Tables and Calcs").Cells(i + 126, 4), Worksheets("Tables and Calcs").Range("B117:DY117"), 0))

Worksheets("Tables and Calcs").Cells(i + 126, 15).Value = Application.VLookup("WPD", Worksheets("Tables and Calcs").Range("B117:DY120"), Application.Match(Worksheets("Tables and Calcs").Cells(i + 126, 4), Worksheets("Tables and Calcs").Range("B117:DY117"), 0))


When I run this, the "WPD" line is giving the same values as the "MBH" line, and only 2 of the 3 lines will work correctly at any time, in any order...

Any idea what might be going on here?

[David A Coop]

Very difficult with what you have provided!

I think you need to change ,0)) at the end to ,0),0)

I think you are missing the range lookup operator for the vlookup.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[josorens]

That seems to have fixed it!

Thank you very much!

[David A Coop]

You're welcome!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".