Lookup problem

[Colin Foster]

Trying to compare 4 lists of parts. What I need is to be able to report
against the first list all items on the other 3 lists that have the same
part number together with their quantities. Then, any items on the second
list need comparing to the 3rd & 4th lists. Finally, the 3rd & 4th lists
need comparing.
The final "report" needs to have 8 columns (list 1 p/no, list 1 qty, list 2
part no, list 2 qty, etc).
I've tried playing with lookups, but it's getting very messy, so I wondered
if anyone had any ideas?
Regards
Colin Foster

 

[Steve Ward]

Colin,

Try using your help files to look up the DSum formula.

This is similar to VLookup, but it allows you to specify
criteria:

DSum(yourrange,columntoreturn,criteria).

When you do the criteria section, you have to write it in
2, 4 ,6 etc.. cells. A bit like this:

ColumnA ColumnB

4 <5

Then for your criteria bit at the end of the formula,
select those 2, 4 etc cells.

Steve Ward

www.excelaid.com