Solved

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

Posted on 2012-03-22
3
454 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
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

830 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