View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bklynhyc Bklynhyc is offline
external usenet poster
 
Posts: 37
Default to link information between two lists

Hi,

I would like to link the amounts over two lists of totals,

first list with reference.

abcd
merchant date amt ref.
1234 06/01/09 500.00 1
1233 06/02/09 100.00 2
1233 06/02/09 100.00 3
1233 06/02/09 100.00 4
1233 06/02/09 100.00 5

second list w/o reference

abcd
merchant date amt ref.
1234 06/01/09 500.00 ?
1233 06/02/09 400.00 ?

I've been using ref. number manually to link them, is there a better way?

Thanks at advance