Lookup Function

[phalcon45]

Now that I know where all the best minds on earth are (this site) Im going to do everything I can to learn all I can!
That being said, is it possible to run a function in a macro that will do a lookup?
For example instead of writing a VLOOKUP string in the actual excel sheet can I have the lookup called and performed within the macro itself and have it return a value from an array within the excel sheet?

Im a real novice where it comes to functions so....

[tigeravatar]

phalcon45,

Yes you can, check out Application.WorksheetFunction

[phalcon45]

Tried to reply but it didnt go through...so here goes again.
OK sounds good. Im just not sure how to put the function into my code.
Right now I have a form that shows me a list of descriptions from a list then the sub sets the value of cell F2 to whatever I select. Then the adjacent cells run VLOOKUP to find the product code and the product price from the array in V2:AA604.
How do I build the function so that I can run it and return the lookup value?
Thanks a thousand times over to everyone

[tigeravatar]

Without seeing your code its difficult to give accurate information, but it should look something like this:

Please Login or Register  to view this content.

[phalcon45]

Worked PERFECT! Thank you. I had something very similar but I had the syntax wrong in the Vlookup function.
You guys are a lifesaver.

[tigeravatar]

You're very welcome

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save