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