| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare data and automatically enter data.
I have 2 worksheets, both with columns for "Site Name" and "Site Number".
Both have site numbers filled in - only one has site name filled in. How do I get Excel to automatically search for the site name on one worksheet and input that info. into the other worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare data and automatically enter data.
Look at VLOOKUP function
=VLOOKUP(siteNumber,Sheet2!A:B,2,0) "Sitenumber" on on Sheet1 e.g in a cell A1,and Columns A& B on Sheet2 contain Site Number/Site Name. =VLOOKUP(A1,Sheet2!A:B,2,0) To allow for errors: =IF(ISNA(VLOOKUP(siteNumber,Sheet2!A:B,2,0)0,"",VL OOKUP(siteNumber,Sheet2!A:B,2,0)) HTH "Tesa M." wrote: I have 2 worksheets, both with columns for "Site Name" and "Site Number". Both have site numbers filled in - only one has site name filled in. How do I get Excel to automatically search for the site name on one worksheet and input that info. into the other worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to enter data then move automatically to new cell? | Excel Discussion (Misc queries) | |||
| AUTOMATICALLY ENTER DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions | |||
| Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
| enter data in cell then run macro automatically | Excel Discussion (Misc queries) | |||
| Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
Hybrid Mode
