ExcelBanter - Excel Updation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel Updation (https://www.excelbanter.com/excel-programming/425902-excel-updation.html)

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

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

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

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

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.