Data lookup function

J

JL Taylor

I have a spreadsheet listing payments received on a specific day of the
month. My workbook contains an individual sheet for each day of the month. I
would like to filter some of that specific data from the daily sheets into a
new sheet.

My daily sheets have the following set up: division, customer, invoice
number, amount of check, salesperson (there's more but not necessary to
list). My summary sheet needs to have these basic fields linked or pulled to
it for only ONE division.

I've tried doing a lookup, vlookup, and IF statement to extract the data.
The only one that worked was vlookup, but it only pulled one row of data. I
have multiple rows and multiple people at that division.

Here's my statement: =VLOOKUP("regional",'1st'!1:65536,9,TRUE)
where "Regional" is my division; "1st" is my daily sheet, and 1:65536 is the
table array, and 9 is the column from which to pull the first piece of info -
in this case the salesperson's name. I have separate columns to set up the
formula to pull the invoice number, the dollar amount, etc.

But this only pulled one salesperson's name and when I try to copy the
formula to pull other salespeople, it doesn't work.

Note: I believe I have to use the full range of the entire spreadsheet for
that day because there's no way of knowing which rows are going to be the
Regional market from day to day. It could be rows 135-150 on the 1st; and
rows 335-360 on the 2nd.

Also, if there's a better function to pull this data please let me know.
 
Z

Zumble

Don't keep data in daily sheets.
Keep all the data together in a an Excel table (as far as possible) and
......
dispaly the data in Excel sheets.
 
J

JL Taylor

Unfortunately, we've been doing it that way for a long time - changing the
procedure is not going to happen. Anyone else have any input on how to
retrieve or access the data?
 

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

Top