lookup a value in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

sheet1:
Column A- List of 20 names
Column B one of six offices listed next to each name
Column C various assignments

Sheet2:
I want to show only those names that have "officeX" listed in column B, and
their assignments in the adjacent cell. This information must be on a
seperate sheet, organized by office.

Any help would be appreciated!
 
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

Modify working code to expand the output. 5
modified pivot table using a macro 2
Lookup, match dates and confirm fase 17
Match or Lookup 6
Populating values in cells based on lookup from other cell. 4
Compare two Sheets 1
Array with many cells from a row but not in order or together 11
Transfer array element offset value to a matched value 3

Back
Top