VBA instead of index small or vlookup formula

[cajand]

Hello,

I have two sheets.

Sheet1 = Matches go here
Sheet2 = Database

In the database I have values in column A, B, and C where A is the "identifier".
I want too match the value in cell C2 in Sheet1 with the values in column A in Sheet2.
I want to return the values column B and C in sheet2 and paste them into the range
C8:C in sheet1

I've only managed to return the 1st match from one column, but I want to return several matches
from both columns.

I want to use this as a sub routine with a button.

Does anybody have a solution?

Thanks!

[sktneer]

You may try something like this......

Please Login or Register  to view this content.

You may change the Sheet Names in red as per your actual sheet names.
Does this help?

[cajand]

You may try something like this......

Please Login or Register  to view this content.

You may change the Sheet Names in red as per your actual sheet names.
Does this help?

Hi!

Thank you!

But I get a "variable not defined" error on "i = 8".
I've only changed the names on the sheets in the code.

[sktneer]

Declare i as long like

Please Login or Register  to view this content.

[cajand]

Works Great! Thanks man!

Is it possible to modify the code so that the when I run the code several times with different values in C2 the
previous results does not get replaced. Instead the new results go in the empty cells below the previous results?

Would be awesome!

[sktneer]

In column C what values are there in the range C1:C7? Are they blank? Or which cell in col. C has value above C8 before running the code first time?

[cajand]

C7:I7 contain headers. so basic text values.
Above that atea Form buttons and such.

[sktneer]

Ok try this.....

Please Login or Register  to view this content.

[cajand]

Worked perfectley! Thanks you so much! Saved me a headache.

[sktneer]

You're welcome.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.