how to use application.worksheetfunction.vlookup

i have the following code:

Please Login or Register  to view this content.

the first line puts the vlookup in the cell but that is not what i want
i want to use the second line instead so it puts the value of the lookup in the cell vs a formula.

how can i do that?

Try:

Please Login or Register  to view this content.

thanks john,

while i was waiting for a reply, i got it working like so:

Please Login or Register  to view this content.

i tried to shorten this but still have errors, can this be done?

If it works as is, not sure how you can shorten it any further.

i didnt like this part of it:

Please Login or Register  to view this content.

can i do something like this?

Please Login or Register  to view this content.

Did you try:

Please Login or Register  to view this content.

yah, i tried that before but it gives me an error: run time error 424 Object required.

this is what i finished with that works:

Please Login or Register  to view this content.

Ok. Trial and Error wins again!

yup, it sure does. love excel and vba, so much power.

thanks again john for your help.