A B C D
Number1 Number2 Date
436542 142165 1/13/2010 #N/A
436542 416041 9/2/2009
1412386 426560 11/24/2009
1470623 1450350 9/10/2009
1477592 1454289 11/20/2009
1477592 1461105 10/14/2009
1478272 1470623 7/13/2009
1479975 1479975 8/25/2009
1484981 1485960 7/13/2009
1485960 1487238 8/25/2009
1485960 1487238 1/13/2010
1487238 1491168 10/26/2009
1502653 1491168 1/13/2010
1502653 1491822 1/13/2010


I have two sets of data is seperate reports. 1 lists number and other info I
need and the other lists Number and date. I added columns B and C from the
sheet with dates and have tried to match data with little luck. I need a
formula for column D that will match the # in column A with Column B and
return the date associated with column B.
ex
1470623 in column A5
1470623 is in column B8
7/13/2009 is in column C8
I want my formula in column D5 to return the date from column C8 7/13/2009
Please help.

Not sure I really understand...

See if this does what you want.

Entered in D2 and copied down:

=IF(COUNTIF(B$2:B$15,A2),INDEX(C$2:C$15,MATCH(A2,B $2:B$15,0)),"")

Format as Date

--
Biff
Microsoft Excel MVP


"HFST04" wrote in message
...
A B C D
Number1 Number2 Date
436542 142165 1/13/2010 #N/A
436542 416041 9/2/2009
1412386 426560 11/24/2009
1470623 1450350 9/10/2009
1477592 1454289 11/20/2009
1477592 1461105 10/14/2009
1478272 1470623 7/13/2009
1479975 1479975 8/25/2009
1484981 1485960 7/13/2009
1485960 1487238 8/25/2009
1485960 1487238 1/13/2010
1487238 1491168 10/26/2009
1502653 1491168 1/13/2010
1502653 1491822 1/13/2010


I have two sets of data is seperate reports. 1 lists number and other info
I
need and the other lists Number and date. I added columns B and C from the
sheet with dates and have tried to match data with little luck. I need a
formula for column D that will match the # in column A with Column B and
return the date associated with column B.
ex
1470623 in column A5
1470623 is in column B8
7/13/2009 is in column C8
I want my formula in column D5 to return the date from column C8 7/13/2009
Please help.

In D5 enter:

=VLOOKUP(A5,B2:C15,2)
and format D5 as a Date.
--
Gary''s Student - gsnu200909


"HFST04" wrote:

A B C D
Number1 Number2 Date
436542 142165 1/13/2010 #N/A
436542 416041 9/2/2009
1412386 426560 11/24/2009
1470623 1450350 9/10/2009
1477592 1454289 11/20/2009
1477592 1461105 10/14/2009
1478272 1470623 7/13/2009
1479975 1479975 8/25/2009
1484981 1485960 7/13/2009
1485960 1487238 8/25/2009
1485960 1487238 1/13/2010
1487238 1491168 10/26/2009
1502653 1491168 1/13/2010
1502653 1491822 1/13/2010


I have two sets of data is seperate reports. 1 lists number and other info I
need and the other lists Number and date. I added columns B and C from the
sheet with dates and have tried to match data with little luck. I need a
formula for column D that will match the # in column A with Column B and
return the date associated with column B.
ex
1470623 in column A5
1470623 is in column B8
7/13/2009 is in column C8
I want my formula in column D5 to return the date from column C8 7/13/2009
Please help.