Lookup Function

[Dedicated1]

Unique identifer is the project number. I need to search for all project numbers listed on worksheet one to match any project numbers on worksheet two. If a project number matches I need to pull amount linked to project# to worksheet one. Do I use the Lookup Function for this? If so, how?

WorkSheet one Worksheet two
Project# Amount Project# Amount Acutals
2012 2010 22,000
2014 2012 29,000
2014 32,000

[Dav]

if the values in sheet2 are unique yes you do. If they are not and are say monthly amounts so more than one appears you need to use sumif

if the project number is in a2 something like
=VLOOKUP(A2,Sheet2!$A$2:$C$5,2,FALSE) for project amounts

or
=VLOOKUP(A2,Sheet2!$A$2:$C$5,3,FALSE) for actuals

of

sumif(sheet2!$a$2:$a$5,a2,sheet2!$b$2:$b$5)
and
sumif(sheet2!$a$2:$a$5,a2,sheet2!$c$2:$c$5)


obviously the ranges need extending to cover the data in sheet2

Regards

Dav