Vlookup macro doesn't show data in column G

[MaartenRo]

Hi,

I have created a workbook with two sheets. With a Vlookup macro i want to display in the columns the data in the list in the second sheets.
Somehow column "G" in the first sheet doesn't show any results. What am i doing wrong here?

Any input is much appreciated!

[BadlySpelledBuoy]

Your VLOOKUP is trying to return a value from the 14th column in the range, however the range selected is A:M which is only 13 columns.

Which column from the second sheet are you trying to return from?

BSB

[BadlySpelledBuoy]

Try changing this line:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

BSB

[MaartenRo]

Thanks i understand the problem now, i didn't refer to the full matrix in the second sheet.

[BadlySpelledBuoy]

Exactly that.

Glad I couple help

BSB