|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
You could try a Vlookup.
|
Tags |
auto fill, cell references, matching |
Thread Tools | |
Display Modes | |
|
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 |