|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
07-18-2014, 07:08 AM
|
|||
|
|||
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.
|
|
#2
09-12-2014, 07:51 AM
|
|||
|
|||
|
You could try a Vlookup.
|
|
|
| Tags |
| auto fill, cell references, matching |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help Coloring a cell in Sheet one if data is missing from another sheet
|
Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
| Data not showing from Access linked work sheet | shabbaranks | Excel | 0 | 01-08-2014 02:52 AM |
| Auto populate invoice (including description) from data sheet | agenevieve | Excel | 2 | 12-06-2012 04:48 AM |
| Filling the consecutive cell by day. | aligahk06 | Excel | 1 | 09-15-2010 08:17 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode