Solved

Excel database - show correspnding Product Description, Price, Qty and so on

Posted on 2012-03-22
3
455 Views
Last Modified: 2012-03-23
Hi,

I would like to enquire. I am using Microsoft Excel 2007.

I have a excel file database probably 5000 rows. It consists of lots of rows and columns. I have attributes like Product Code, Product Description, Price, Qty and so on.

Is there a way to pull out just a few rows i want? For example, I only want to view Product Code #1, #178, #789, #1987 only.

Perfect Scenario: For example, i key in #1, #178, #789, #1987 all in separate cell, it will auto show me the correspnding Product Description, Price, Qty and so on.
0
Comment
Question by:dandeliondream
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 42

Assisted Solution

by:dlmille
dlmille earned 50 total points
ID: 37755830
Please provide a sample workbook.

Would a data filter/advanced filter work where you hit a button and the database is filtered to what you were looking for?

Alternatively, formulas can be built to pull using Vlookups or other lookup-related functions.

Dave
0
 
LVL 40

Accepted Solution

by:
als315 earned 450 total points
ID: 37755839
Vlookup function can do it, but for each cell (Product Description, Price, Qty...) you should have separate vlookup. Look at example
Vlookup.xls
0
 
LVL 3

Author Closing Comment

by:dandeliondream
ID: 37756164
easy to uderstand. thankQ!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question