Lookup problem

  • Thread starter Thread starter Colin Foster
  • Start date Start date
C

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
 
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
Click to expand...

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

Steve Ward

www.excelaid.com
 
Back
Top