• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 59
  • Last Modified:

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
0
jskfan
Asked:
jskfan
  • 4
  • 3
1 Solution
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
jskfanAuthor Commented:
will try it later
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now