Solved

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

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

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 39

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

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 …
The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

808 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