A simple VLOOKUP formula will do this.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kristina1976 via OfficeKB.com" <u51495@uwe wrote in message
news:99782fa7bf8ff@uwe...
Hello there,

I am looking for some help. I have two spreadsheets and I need to match
the
policy number from worksheet 1 and 2 and if they are a match then add the
renewal date in speadsheet #1.

Any help is appreciated


ie.

Worksheet 1
A B C
NAME Policy # Renewal date
John 32 ?
Chris 16 ?
Brian 15 ?


Worksheet 2

A B
Policy # Renewal Date
32 12/12/2009
24 15/01/2001
15 15/03/2006
16 18/02/2003
18 24/09/2006
17 17/06/2005

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200907/1