VLOOKUP to Macro

[Vincent.Eymard]

Hi everyone,
Could youu help me convert this short VLOOKUP formula into a Macro?
Appreciate your help. Thank you.

Formula:
=VLOOKUP(AA6,AA8:AB10,2)

[Vincent.Eymard]

Oh by the way I want the results to appear on E11.. Hope you could help.
Thanks.

[Vincent.Eymard]

Appreciate your help on this. Thanks.

[arthurbr]

Please allow 24 hrs before bumping - Thx

[royUK]

Why convert it into a macro? What do you want to do?

[Vincent.Eymard]

Hi Roy,
Im trying to build something from a Spreadsheet that was handed over to me.
Did a search on the forum if I could find something similar to what I need but with no luck.
I can do Vlookup but that's not really what I was looking for.
I was hoping I could do this in the form of VBA. Any help will be appreciated.

Hi Arthur,
My apologies on bumping this thread up. Getting desperate I guess, wont happen again.
Thank you.

[Vincent.Eymard]

Any suggestions? Hope you guys could help me. Thank you.

[arlu1201]

This is what you need:

Please Login or Register  to view this content.

Next time you need something, try recording the macro to see what code you obtain. Then, you can tweak it as necessary.

[Andrew.Trevayne]

Vlookup is the way to do this.

[Vincent.Eymard]

@arlu1201
Thanks, this is actually pasting the formula on the cell.
Im trying to avoid to have the formula there. I copy and paste this column and when I do I get the NA# since it was in fact a formula. Seems this is a hopeless case.

Thanks anyways for your help.

[royUK]

If you want to use VBA then I would use the .Find method, see the VBA Help files for an example. For more help post an example workbook

[Vincent.Eymard]

Closing thread. Got help from another forums.
Thanks anyways.

[royUK]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

[Vincent.Eymard]

I understand what you are saying and I've read the forum rules thank you.
I have been trying to get help from here but without any luck hence I had to resort to finding other means.
After much waiting it is only now that I posted on other site and was given a response in an instant.
And I immediately closed this thread after resolving the problem so I do not see why you'd say I do not comply.
I was hoping Forum Admins will be helpful. Didn't get that here.
But thanks anyways.

Cheers!