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

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.
LVL 3
dandeliondreamAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Vlookup function can do it, but for each cell (Product Description, Price, Qty...) you should have separate vlookup. Look at example
Vlookup.xls
0
 
dlmilleConnect With a Mentor Commented:
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
 
dandeliondreamAuthor Commented:
easy to uderstand. thankQ!
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.

All Courses

From novice to tech pro — start learning today.