View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tessa Tessa is offline
external usenet poster
 
Posts: 6
Default Vlookup and/or combing data from two worksheets

HELP! I have two worksheets. One is the Master Account list and the other is
the Aging. I have made it so both have the same column headings (Account,
Name, Addresss, current, 7-30, 30-60 etc). What I need to do is combing the
two so that the aging shows up on the Master in the row with the
corresponding account. However, there are many more accounts on the Master
than on the Aging so excel will need to look up or find the data.
I have tried Vlookup but I cant get it to work. I feel like I am missing a
crucial piece of info somewhere.


Any help would be appreciated. Hopefully I am making sense.