Hi-

I have a macro already written which manipulates a worksheet, but
need to update each cell in sheet1(coulumn 1) based on informartion o
3rd colum cell. I have written all the data in sheet 2 of th
worksheet. I need to do a comparison with worsheet 1 cell (column 3) t
worksheet 2 and find the matching value and update cell of column one.

FOr example:

sheet 1 for worksheet has:

12 JOHN
13 SMITH
13 KEERY

Sheet 2 of same Worsheet has

ANALYST JOHN
DENTIST SMITH
OFFICER KEERY

I need to match column 2 of sheet 1 to column 2 for sheet 2 and updat
column1 of sheet one.

The OUTPUT SHOULD BE in sheet 1:

ANALYST JOHN
DENTIST SMITH
OFFICER KEERY


I would extremly appreciate if someone could help me with this t
update my macro to do so.....HELP!!!

Thank You
Neelim

--
Message posted from http://www.ExcelForum.com

In sheet1, column 1 put in the formula

=Index(sheet2!A:A,match(B1,Sheet2!B:B,0),1)

Then drag fill down the column.

--
Regards,
Tom Ogilvy

"Neelima " wrote in message
...
Hi-

I have a macro already written which manipulates a worksheet, but I
need to update each cell in sheet1(coulumn 1) based on informartion on
3rd colum cell. I have written all the data in sheet 2 of the
worksheet. I need to do a comparison with worsheet 1 cell (column 3) to
worksheet 2 and find the matching value and update cell of column one.

FOr example:

sheet 1 for worksheet has:

12 JOHN
13 SMITH
13 KEERY

Sheet 2 of same Worsheet has

ANALYST JOHN
DENTIST SMITH
OFFICER KEERY

I need to match column 2 of sheet 1 to column 2 for sheet 2 and update
column1 of sheet one.

The OUTPUT SHOULD BE in sheet 1:

ANALYST JOHN
DENTIST SMITH
OFFICER KEERY


I would extremly appreciate if someone could help me with this to
update my macro to do so.....HELP!!!

Thank You
Neelima


---
Message posted from http://www.ExcelForum.com/