Easy lookup question.

[proctk]

I'm trying to use Vlookup to

match the value in column A on a sheet called Budget to the value in column A on a sheet called tracking. when a match is found I want it to sum the value in column D on the sheet tracking(location of formula) for each match and place the result on the sheet called Budget.

Any help thanks

 

[fairwinds]

Hi,

Try:

=SUMIF(Tracking!A:A,Budget!A2,Tracking!D:D)