View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default matching two columns and adding info

in column B of sheet1:

=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,0)),"",VLOOKUP(A1 ,Sheet2!A:B,2,0))

and copy down

HTH

"newyorkjoy" wrote:

I wrote this question earlier, but I was not clear about what I needed. I
have two worksheets. Sheet 1 has a column with ALL the dates from 1900 until
the present. Sheet 2 has a column A with SOME of the dates and column B with
data to match those dates. I need excel to find the dates in sheet1 that
match the dates in sheet2, and then to put the data that is in sheet 2 into
sheet 1.

Worksheet 1 Worksheet 2
column A Column A Column B
1/1/1900 1/2/1990 -1
1/2/1900 1/3/1990 1
1/3/1900 1/4/1990 3

I will need worksheet 1 to have a column B that will show the information in
column B of worksheet 2 matching the correct dates.

I appreciate all your help. Thanks

--
newyorkjoy
thanks for the help!