lookup

C

choice

i have a range (a1:g5000) sorted by date, the same date can be used in multiple rows, i need to lookup up a date and have it return all info for each date
 
D

David McRitchie

I don't see that either <grin>
There are multiple argument lookups, but I think the
poster would be more interested in filtering.
i have a range (a1:g5000) sorted by date, the same date can be used
in multiple rows, i need to lookup up a date and have it return all
info for each dateseld be
Click to expand...

A little bit light on how they want to to the lookup, whether they know
the date or have to look it up first. Debra Dalgleish, I think, has some
program invoked filter examples on her site. http://www.contextures.com
look for filter or filtering.

Since the question is skimpy on what is wanted it probably
is is not a programming question. So perhaps a simple filter
is all that is needed.

Auto Filter within...
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel/sumdata.htm#autofilter
Also includes information to undo the filter, don't want anyone having
to restore a file because how to undo wasn't included.


--
 
F

Frank Kabel

Hi Alan
it was too late for this post I think. What I wanted to say was:
I woulds use multiple VLOOKUPs. One for each column, each refering to
the same search criteria.
and after this just a refernce to get the basic understanding of
vLOOKUP :)
 
C

choice

i currently have multiple vlookups (about 350000), but there are only about 10 a day that needs to be looked up...so i was wondering if there was a way to use less equations or programming, this worksheet is saved about every 2 minutes...so with all those equations it takes a LOT longer to save
 
F

Frank Kabel

Hi
if you could explain your spreadsheet layout a little bit more there
may be alternatives. Honestly I can't think of a situation where I
would need 350,000 formulas in an Excel sheet. If an application
requires that much lookups Excel is probably not the right tool
 
C

choice

column A = date of purchas
column b = name of custome
column c = phone numbe
...
column GC = discount

the range is from A2:GC(count of transactions

basically now im using =if(a2=today(),b2,""
same equation for column c,d,e...out to G

then that equation goes down about 10000 rows to cover all the possible trasanaction
 
F

Frank Kabel

Hi
but this would create a lot of blank rows? Why not use 'Data - Filter -
Advanced Filter' for creating a snapshot on a separate sheet or 'Data -
Filter - Autoflilter' to show only the relevant rows.

Another approach would be to put this data in a database and create a
query for this. You may then import this query in Excel. Also consider
using pivot tables for aggregations
 
Top