matching data from one work sheet to another, then auto filling missing cell information
I have two worksheets with similar data in one work book. I need data from one worksheet auto filled or transferred to another by specific names. On one worksheet I have a list of houses(column1) and corresponding addresses(column2). I have houses called bluehouse1 and bluehouse2 in column 1 listed multiple times with corresponding addresses of 1234 and 1235 in column 2. On the other worksheet I have a list of house names but no addresses. I need to use the first worksheet to get addresses listed in the second worksheet but cannot figure out a formula to complete this and doing it one at a time takes too long. Please help. Any suggestions? I attached a workbook that is similar to what I need.
|