vlookup question

[pem089]

I have a 2 worksheets that have data on each. I need to bring data over from one worksheet to the other. The data that I need is in multiple columns spread through out. Not right next to one another. Is there a way that I can select multiple columns to bring over the information. Or do I have to do a vlookup for each column that I want. I've tried to work this out, but it has me stumped. Is there any advice that anyone can give to me to get a solid understanding of the rules, do's and don'ts on vlookup. I need to master this for my job.

Thanking anyone in advance.

PEM089

 

[Smitty]

Welcome to the Board!

It'll help if you post a shot of what you've got and what you want. Follow the link in my sig for how to do it.