| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with IF function...
I need to create an IF function that compares column "C" of two workbooks and if they are the same(contains the same information) then copy the contents of cell "I" to the first workbook in cell "G". Can anybody help me? Joe -- JosephWood ------------------------------------------------------------------------ JosephWood's Profile: http://www.excelforum.com/member.php...o&userid=36776 View this thread: http://www.excelforum.com/showthread...hreadid=564916 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with IF function...
What's In I and G ?? Think you need to post more info This link might help with the comparing Column C in both workbooks http://www.cpearson.com/excel/duplicat.htm VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564916 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with IF function...
Column "I" has either an e-mail address or a fax number. "G" has the words fax# or e-mail in it. Joe VBA Noob Wrote: What's In I and G ?? Think you need to post more info This link might help with the comparing Column C in both workbooks http://www.cpearson.com/excel/duplicat.htm VBA Noob -- JosephWood ------------------------------------------------------------------------ JosephWood's Profile: http://www.excelforum.com/member.php...o&userid=36776 View this thread: http://www.excelforum.com/showthread...hreadid=564916 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with IF function...
"JosephWood" wrote
in message ... I need to create an IF function that compares column "C" of two workbooks and if they are the same(contains the same information) then copy the contents of cell "I" to the first workbook in cell "G". Can anybody help me? =IF(C1=[Book2]Sheet1!$C$1,IF(I1<"",I1,""),"") I assume that if cell I is blank, or if the column C values don't match, you want blank in G? -- David Biddulph |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with IF function...
Yes. I do want column "G" blank. I will try this formula in the morning. Thank you very much. Joe David Biddulph Wrote: "JosephWood" wrote in message ... I need to create an IF function that compares column "C" of two workbooks and if they are the same(contains the same information) then copy the contents of cell "I" to the first workbook in cell "G". Can anybody help me? =IF(C1=[Book2]Sheet1!$C$1,IF(I1<"",I1,""),"") I assume that if cell I is blank, or if the column C values don't match, you want blank in G? -- David Biddulph -- JosephWood ------------------------------------------------------------------------ JosephWood's Profile: http://www.excelforum.com/member.php...o&userid=36776 View this thread: http://www.excelforum.com/showthread...hreadid=564916 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
