Hi there, I'm wondering which would be the most eficient way to search for
and extract data from anywhere from 1000 to 2000 rows of data. Would the use
of a worksheet function sufice or would VBA code be better?
Here's the senerio:

A B C D E F G .......
1 101 204 $5.99 12 1 ? ?
2 104 201 $4.99 10 2 ? ?
3 101 204 $2.99 3 4 ? ?
4 105 202 $1.99 11 3 ? ?
5 102 200 $4.59 20 5 ? ?
6 102 200 $1.50 30 1 ? ?
7 101 208 $6.49 25 1 ? ?
ETC...
I need to extract information in many ways.... i will need to do about 50
separate and different searches and extracts from this data to a specific
cell. So I'm thinking that the re-calculating of this workbook would be too
demanding. Here are two examples of what I'm looking for... The first is
searching through column A til the end (End is always unknown and changing)
let's say we're searching for 101 in column A. It would find 3 results, in
this case. I would then need the sum from columns(E*D*C) from rows 1,3,7. So
cell AA100 would get this grand total of $270.01.
The second method would be the same but would perform a second search in
column B... so we might look for 101 in column A and 208 in column B then do
the same mathematics. I hope I've explained this OK... I think I'm confused!

Thanks Craig