Need help with excel functions retrieving data

  • Thread starter Thread starter LUE42
  • Start date Start date
L

LUE42

I hope someone may be able to help me out...

I have a spreadsheet that is an output of all computers on our network
and what applications are installed on them

The spreadsheet is organized by all computer names listed in column A,
and all software listed in column B.

So, in column A, you will see multiple entries for each computer and
in column B, you will see a different software name in each of the
rows next to the computer name in column A.

On another sheet, I would like to be able to choose from a dropdown
list of computer names (grabbed from column A) and have it display all
the software that is installed on the computer (column B). I have
already made that dropdown list and it is at C2 on the sheet.

So, on this sheet, I would like to be able to quickly be able to
select a computer name and have it list all the software that is on
the PC. I am doing this on a different sheet as there is a bunch of
other lookups I am doing that make up this page.

Thank you very much

Cory
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a sales quote sheet - sum totals by license type 1
Excel lookup across entire workbook 1
moving rows to another sheet 3
VBA - retrieve data on last create named range from previous inserted named range 0
Data Validation and drop-down list using IF, AND and what else? 8
Inserting cells (shift cells right) using macro 0
Figuring out a lengthy formula. Probably quite simple... 3
Auto data entry 2

Back
Top