creating a macro in excel - I'm new and stuck

I have one sheet with Cols. A, B, C - I need the macro to look at each row in C (on Sheet 1), find corresponding data on Sheet 2 (which also has Cols. A, B C) take info from Cols. B, C and put into Cols. A, B on Sheet 1
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You don't need a macro to do this use the vlookup function of excel to to do it, if you have post reject this answer and I will give you more help
sonneAuthor Commented:
I tried that and it didn't work - here is what I did
Look_upvalue  Sheet!2$A$2:$A$7000
Table_array  C2 (from sheet 1)
Col_index_num   2 (from sheet 1)
and then I tried

making information in both sheets begin A, B, C - tried vlookup - but it only return what was in Col A sheet 2

Sheet 1
Billing Name  Address   Phone

Sheet 2
Phone   Billing Name   Address

any further help will be appreciated - especially since it has so many records

I have the solution for you as a sheet email me at this address and I will mail it back as an attachment monday evening.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Send me an Email so I can send you the spreadsheet
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.