Solved

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

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now