Type Mismatch: Vlookup

[Unbalanced]

The external for loop is suppose to increment from 1-12, one for each month. The months are separated by columns and that is why I wish to increment the column referenced by vlookup.

However I do not know the proper syntax to increment the column reference and are therefore getting mismatch errors.

Thank you for your assistance.

Please Login or Register  to view this content.

The specific lines in question are:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Also, what exactly are you trying to do?