Thread: Looking up data from one place to another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Davis Richard Davis is offline
external usenet poster
  
Posts: 2
Default Looking up data from one place to another
I have a sheet that has a user in cells D3 to H3 and a Account ID in cell B10
to B20. I have another sheet(sheet2) that list all the Account ID's in
Column A, all the Users In column B and the 'Calls needed' in column C. I
want to update the intersecting cells with the Calls needed on sheet based on
the intersection of user ID and Account ID. Can someone help?
Reply With QuoteReply With Quote