VLookup with for loop

[nosense]

I have a probelm with vlookup function used with for loop.

In the file attached you can see what i am trying to achive. I need values from e7:e11 that are corresponding to the letters in range c7:c11 to be allocated to the correspodning entries in another table. I need to use the function vlookup and for each cell.

This i swhat i managed to workout s far but I am stuck now

Please Login or Register  to view this content.

[simcode]

try

Please Login or Register  to view this content.

[nosense]

try

Please Login or Register  to view this content.

This is not pasting where it should.
I need the values to be pasted using vlookup i.e. to corresponding entries in the right hand side table...

[nosense]

I was also thinking that i will need to use match function to find appropriate row number to paste a value but not sure

Please Login or Register  to view this content.

[Richard Buttrey]

..Why do you need to use VBA at all? why not just enter the VLOOKUP in K7:K11 directly?

[nosense]

..Why do you need to use VBA at all? why not just enter the VLOOKUP in K7:K11 directly?

My actual spreadsheet is much more complex and I have not pasted it here just created an example instead. The work I do needs to be done in a way I am asking .

Thanks

[Richard Buttrey]

My actual spreadsheet is much more complex and I have not pasted it here just created an example instead. The work I do needs to be done in a way I am asking .

Thanks

Examples often don't reflect the production data which is why we more often than not prefer to see the real data, if only a subset.

Since you are hardcoding the range i7:i11 it's not at all apparent why you NEED a macro. It would be nice to understand why you think that since that often helps us understand the overall process. Even if you do want a macro why not just write the VLOOKUP into the range

i.e.

Please Login or Register  to view this content.

[Kaper]

Try (based on your original one):

Please Login or Register  to view this content.

note that Richard's comments are still valid, I just corrected, what I seen as obviously wrong approach in your macro - using asd variable, mismatched rows and columns in Cells(11, asd), using myrange1 in vlookup...