Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel- Conditional Formatting
I need help setting up a conditional formatting formula. In one
workbook I have 2 sheets. Sheet 1 has a list of names with addresses- (street, city, state, and zip- are all in different columns, but in the same row); in Sheet 2 I have a list of names but the addresses are not populated. I am trying to creat a formula which says: "If the name in sheet 1 matches the name in sheet 2, then take the street address from sheet 1 and post it in sheet 2, take the city from sheet 1 and post it in sheet 2, etc.." Anyone have any Ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel- Conditional Formatting
HI
You could use Vlookup function or something like this; =IF(Sheet1!A5=Sheet2!A5,Sheet1!B5,"") and change B5 For C5 I Assume. HTH John wrote in message ... I need help setting up a conditional formatting formula. In one workbook I have 2 sheets. Sheet 1 has a list of names with addresses- (street, city, state, and zip- are all in different columns, but in the same row); in Sheet 2 I have a list of names but the addresses are not populated. I am trying to creat a formula which says: "If the name in sheet 1 matches the name in sheet 2, then take the street address from sheet 1 and post it in sheet 2, take the city from sheet 1 and post it in sheet 2, etc.." Anyone have any Ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel- Conditional Formatting
On Jan 30, 12:08*pm, wrote:
I need help setting up a conditional formatting formula. *In one workbook I have 2 sheets. *Sheet 1 has a list of names with addresses- (street, city, state, and zip- are all in different columns, but in the same row); in Sheet 2 I have a list of names but the addresses are not populated. I am trying to creat a formula which says: "If the name in sheet 1 matches the name in sheet 2, then take the street address from sheet 1 and post it in sheet 2, take the city from sheet 1 and post it in sheet 2, etc.." Anyone have any Ideas? Great- Got it. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel- Conditional Formatting
You're welcone
wrote in message ... On Jan 30, 12:08 pm, wrote: I need help setting up a conditional formatting formula. In one workbook I have 2 sheets. Sheet 1 has a list of names with addresses- (street, city, state, and zip- are all in different columns, but in the same row); in Sheet 2 I have a list of names but the addresses are not populated. I am trying to creat a formula which says: "If the name in sheet 1 matches the name in sheet 2, then take the street address from sheet 1 and post it in sheet 2, take the city from sheet 1 and post it in sheet 2, etc.." Anyone have any Ideas? Great- Got it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting in excel | New Users to Excel | |||
Conditional formatting in Excel | New Users to Excel | |||
conditional formatting in excel | Excel Worksheet Functions | |||
Conditional Formatting in Excel | Excel Worksheet Functions | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |