Create Worksheet Data from existing worksheets

I have an Excel Spreadsheet shown in the first screenshot below. It has columns: Cust-Name, Purchase ,Expiration.
cust
There is a another  worksheet that has Name (which is the same as Cust-name on the  other worksheet), Price, Provider.
prov
I would like to have a new worksheet that  combines the above worksheets, while keeping data relevant.
so the results will be like this :
wanted
Thank you
jskfanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

peter mostmansIT Developer & AnalistCommented:
could this be what you're looking for : see attachment ?
vlookup.xlsx
0
jskfanAuthor Commented:
Can you please elaborate on how you came up with Sheet3. which part of it is manual and which part of it is using formula.?
Step by step will be much clearer .
Thank you
0
peter mostmansIT Developer & AnalistCommented:
Columns D and E of Sheet3 are formulas.  When you put your cursor in one of the cells of these columns you can see then contents of it.
0
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

jskfanAuthor Commented:
It did not work for me
0
jskfanAuthor Commented:
Can you Explain it step by step how you set up the function. I copied and pasted yours with the same Cells  reference but it did not work
0
peter mostmansIT Developer & AnalistCommented:
1. In sheet1 copy A1:B4  and paste it to sheet3 cell A1
2. In sheet3, position in D2 and  type =VLOOKUP($A2;Sheet2!$A$1:$C$5;2;FALSE)    => Make sure you type the '=' also
3. Copy this cell down to the bottom
4. Position in E2 and type =VLOOKUP($A2;Sheet2!$A$1:$C$5;3;FALSE)  => => Make sure you type the '=' also
5. Copy this cell down to the bottom

Hope this helps.

If not, then please include your last attempt as attachment
0

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
jskfanAuthor Commented:
will try it later
Thank you
0
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
Scripting Languages

From novice to tech pro — start learning today.