View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Robert[_30_] Robert[_30_] is offline
external usenet poster
 
Posts: 44
Default Lookup variabel field in variabel sheet

Column K contains amounts which I would like to see in the summary
sheet. Simply said, in the summary sheet I would like to have an
overview which amount of dividends (K) is received per portfolio (A1).
So I have 2 values in the summary sheet on which I would like to apply
the lookup:
1. Portfolio code (match with one of the 20 sheets)
2. Trial item (retrieve the amount from K that of which the name in
column J matches Dividends receivable)

HTH

Robert