the massive table

Define massive. 200 columns by 17,500 rows? 10 columns by 235 rows?

list only the key information

how many items comprise the key information? 200? 10?

Biff

"Sarah - Sydney" <Sarah - wrote in message
...
Hi, i hope I can explain this correctly in words.

What i'm trying to do is create a report that draws information from a
large
table. The report will only be drawing on some of the aspects of the
larger
table. I have tried the LOOKUP functions and they are not working in this
case. Maybe there are too many values?

For example there are many oranges, apples, and pears listed in the
report,
they have all different project numbers, start dates, reporting dates. I'm
trying to produce a report on the oranges that list only the key
information
that I need from the massive table. I have tried the vlookup function with
just the project numbers (i have typed theses into the new worksheet in
hope
it would this number to draw on the rest of the information I need from
the
table) but this does not work.

Has anyone done this before and can help me?