Match and Insert Stump.

[fenhow]

Hi,

I have two worksheets.

Worksheet 1 has Col ID and Col Name and Col Address
Worksheet 2 has Col ID and Col Address

Is there a way I can write a formula where Worksheet 1 Col ID and Worksheet 2 Col ID match It places the Worksheet 2 Col Address into the Worksheet 1 Col Address.

I cannot do a simple sort, copy paste because there are many more ID's in Worksheet 2.

Thanks.

Fen How

 

[namliam]

VLookup will save your day, learn all about it in the excel help