VBA use Application.VLookup and Application.HLookup together

Hi everyone,

I have a table with multiple numbers on the left-hand side column and String value on the first row as headers.

I get one number from a different spreadsheet and then I match that with the numbers on the left-hand side using vlookup. Then I need to use some matching function (such as HLookup) to find the column with the right header from which to pick the right output for the vlookup. At the moment the code looks like this:

Please Login or Register  to view this content.

For some reason, the code is not outputting anything, nor is it crashing. Any ideas? thanks

What are the values of all of your variables when this line executes? i, Col1, Plan, List, col2, Plan_1, Plan_2, value

The most helpful thing would be to attach your file. See yellow banner at the top of the page.

I wasn't asking for definitions, although that is helpful. I am looking for examples of their actual values when this occurs.

I appreciate the sensitivity of your data, although when calling worksheet functions from code it happens very often that the issue is in the data, not the code.

Using fake data, or simply deleting all sensitive data would help.
By your words, it seems using INDEX(MATCH,MATCH..) would do the trick.

Application.VLookup(Worksheets(List).Cells(i, col2).Value, Worksheets(Plan).Range(Plan_1 & "2:" & Plan_2 & "200"), value, False)

in which, value is in column count position. What is it?

You can test by set any Cell = Vlookup, then run the code to see if it works.