| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Updation
Greetings,
I am using Microsoft Office excel 2003. I have a requirement where I have to compare two sheets within an excel and needs to update columns of sheet1 with the respective row value from sheet2. Pseudocode is: 1) Compare columnA (of Sheet1) and ColumnA (of sheet2) of excel say test.xls 2) If value matches anywhere, update ColumnB, ColumnC (of Sheet1) with value from ColumnB, ColumnC (of Sheet2) Can anyone please advise me here? Any help would be appreciated. TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Updation
Use this formula in Sheet1; and copy those to other cells in col B and C
Columb B1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,2) Columb C1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,3) If this post helps click Yes -------------- Jacob Skaria "test" wrote: Greetings, I am using Microsoft Office excel 2003. I have a requirement where I have to compare two sheets within an excel and needs to update columns of sheet1 with the respective row value from sheet2. Pseudocode is: 1) Compare columnA (of Sheet1) and ColumnA (of sheet2) of excel say test.xls 2) If value matches anywhere, update ColumnB, ColumnC (of Sheet1) with value from ColumnB, ColumnC (of Sheet2) Can anyone please advise me here? Any help would be appreciated. TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Updation
On Mar 22, 10:19*am, Jacob Skaria
wrote: Use this formula in Sheet1; and copy those to other cells in col B and C Columb B1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,2) Columb C1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,3) If this post helps click Yes -------------- Jacob Skaria "test" wrote: Greetings, I am using Microsoft Office excel 2003. I have a requirement where I have to compare two sheets within an excel and needs to update *columns of sheet1 with the respective row value from sheet2. Pseudocode is: 1) Compare columnA (of Sheet1) and ColumnA (of sheet2) of excel say test.xls 2) If value matches anywhere, update ColumnB, ColumnC (of Sheet1) with value from ColumnB, ColumnC (of Sheet2) Can anyone please advise me here? Any help would be appreciated. TIA- Hide quoted text - - Show quoted text - Jacob, It works. Thank alot. One quick clarification, cells which does not have any matching value, I want to keep them as it is. In this case it is getting filled with "N/A" value. How can I avoid this? TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Updation
Dear, please try
Columb B1=IF(ISNA(MATCH(A1,Sheet2!A$1:A$4,0)),"",INDEX(Sh eet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0),2)) Columb C1=IF(ISNA(MATCH(A1,Sheet2!A$1:A$4,0)),"",INDEX(Sh eet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0),3)) If this post helps click Yes -------------- Jacob Skaria "test" wrote: On Mar 22, 10:19 am, Jacob Skaria wrote: Use this formula in Sheet1; and copy those to other cells in col B and C Columb B1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,2) Columb C1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,3) If this post helps click Yes -------------- Jacob Skaria "test" wrote: Greetings, I am using Microsoft Office excel 2003. I have a requirement where I have to compare two sheets within an excel and needs to update columns of sheet1 with the respective row value from sheet2. Pseudocode is: 1) Compare columnA (of Sheet1) and ColumnA (of sheet2) of excel say test.xls 2) If value matches anywhere, update ColumnB, ColumnC (of Sheet1) with value from ColumnB, ColumnC (of Sheet2) Can anyone please advise me here? Any help would be appreciated. TIA- Hide quoted text - - Show quoted text - Jacob, It works. Thank alot. One quick clarification, cells which does not have any matching value, I want to keep them as it is. In this case it is getting filled with "N/A" value. How can I avoid this? TIA |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Updation
On Mar 22, 11:25*am, Jacob Skaria
wrote: Dear, please try Columb B1=IF(ISNA(MATCH(A1,Sheet2!A$1:A$4,0)),"",INDEX(Sh eet2!A$1:C$4,MATCH(A1,She*et2!A$1:A$4,0),2)) Columb C1=IF(ISNA(MATCH(A1,Sheet2!A$1:A$4,0)),"",INDEX(Sh eet2!A$1:C$4,MATCH(A1,She*et2!A$1:A$4,0),3)) If this post helps click Yes -------------- Jacob Skaria "test" wrote: On Mar 22, 10:19 am, Jacob Skaria wrote: Use this formula in Sheet1; and copy those to other cells in col B and C Columb B1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,2) Columb C1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,3) If this post helps click Yes -------------- Jacob Skaria "test" wrote: Greetings, I am using Microsoft Office excel 2003. I have a requirement where I have to compare two sheets within an excel and needs to update *columns of sheet1 with the respective row value from sheet2. Pseudocode is: 1) Compare columnA (of Sheet1) and ColumnA (of sheet2) of excel say test.xls 2) If value matches anywhere, update ColumnB, ColumnC (of Sheet1) with value from ColumnB, ColumnC (of Sheet2) Can anyone please advise me here? Any help would be appreciated. TIA- Hide quoted text - - Show quoted text - Jacob, It works. Thank alot. One quick clarification, cells which does not have any matching value, I want to keep them as it is. In this case it is getting filled with "N/A" value. How can I avoid this? TIA- Hide quoted text - - Show quoted text - Jacob, It worked. Thanks alot for your help. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Updation
On Mar 22, 11:25*am, Jacob Skaria
wrote: Dear, please try Columb B1=IF(ISNA(MATCH(A1,Sheet2!A$1:A$4,0)),"",INDEX(Sh eet2!A$1:C$4,MATCH(A1,She*et2!A$1:A$4,0),2)) Columb C1=IF(ISNA(MATCH(A1,Sheet2!A$1:A$4,0)),"",INDEX(Sh eet2!A$1:C$4,MATCH(A1,She*et2!A$1:A$4,0),3)) If this post helps click Yes -------------- Jacob Skaria "test" wrote: On Mar 22, 10:19 am, Jacob Skaria wrote: Use this formula in Sheet1; and copy those to other cells in col B and C Columb B1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,2) Columb C1=INDEX(Sheet2!A$1:C$4,MATCH(A1,Sheet2!A$1:A$4,0) ,3) If this post helps click Yes -------------- Jacob Skaria "test" wrote: Greetings, I am using Microsoft Office excel 2003. I have a requirement where I have to compare two sheets within an excel and needs to update *columns of sheet1 with the respective row value from sheet2. Pseudocode is: 1) Compare columnA (of Sheet1) and ColumnA (of sheet2) of excel say test.xls 2) If value matches anywhere, update ColumnB, ColumnC (of Sheet1) with value from ColumnB, ColumnC (of Sheet2) Can anyone please advise me here? Any help would be appreciated. TIA- Hide quoted text - - Show quoted text - Jacob, It works. Thank alot. One quick clarification, cells which does not have any matching value, I want to keep them as it is. In this case it is getting filled with "N/A" value. How can I avoid this? TIA- Hide quoted text - - Show quoted text - Jacob, It worked. Thanks alot for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel OLE link not updation in German XP OS | Excel Discussion (Misc queries) | |||
| Cross Excel Updation | Excel Programming | |||
| Automatic Excel data updation on Sharepoint. | Excel Discussion (Misc queries) | |||
| Excel Problem in detail/updation, deletion | Excel Programming | |||
| Excel VBA - Userform updation/deletion problem | Excel Programming | |||
![test[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
