View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh Dinesh is offline
external usenet poster
 
Posts: 103
Default multiple sheet looks up and match

Sheet1 looks like below

A B C D G

Cust# Date Cust # Date Amount

1256 500

2456 1000

2566 2000



Sheet2

A B C

Cust# Amount Match Function ?

1256 500

2456 1000

2566 2000


I need a formula to match Cust# & $ value of Sheet2 against Sheet1.


Thanks,
Dinesh