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!
|