View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Multiple lookup values and adding multiple rates across togeth

Okay, I think I figured out what you want to do. To do this the easy way
would be to create an array. The first element would be the concatenation of
Employee & Dept. so that you create a unique "Employee" based on each
combination. Then you would read all that the forecast data into an array,
then add the actual data to the array, and then write out the report. In my
opinion, this would be way easier in the long run to set up and maintain.
When I have a bit more time, I'll work on designing this and send to you.