Getting specific rows of data into a 2nd spreadsheet

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

I have a spreadsheet with about 26 columns. The rows of
information are sales invoices.

One of the columns contains a salesperson code.

In a separate spreadsheet I want to extract some of the
row information pertaining to only one salesperson.


What is an excel function for doing this?

Thanks

Joel
 
Hi Joe,

you can use VLOOKUP together with your salesperson code as search
criteria and the respective column as return value

Frank
 
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

Data lookup function 2
Divide 2 pivot table numbers 3
Find data in worksheet area that constantly changes 2
Excel 2007: Three comparisons 1
Using SUMPRODUCT with a VLOOKUP 4
Transferring data from one sheet to another if criteria are met. 6
Help with countif and sumif functions 8
Add Data to Workbook with information from another 1

Back
Top