Vlookup help!

**Txquadrider** · 01-11-2012, 03:48 PM

Hi Everyone,

I am trying to to find a formula that will take and match both colums A & B from the Week 36 sheet and then pull colum 3 from the payment sheet tab, and return the value to colum G on the week 36 tab.

Any help would be greatly apprecaited. I have looked and found many ways to sting these look ups to return a value, but nothing that will look and match two sets of data to return 1 result.

Thanks,
Jake

WRMP Allocations.xlsx

**NBVC** · 01-11-2012, 03:56 PM

Where is column B supposed to find a match in Payment Sheet?

**Txquadrider** · 01-11-2012, 04:01 PM

Sorry about that, I have been looking at it to long.

What I am trying to do is have a formula look at column A (ie 001-33224) in the week 36 tab, and also us the date on the 3rd row in column G. then take those two qualifiers and match them to columns A & B on the payment sheet tab to return the value from column 3 from the payment sheet tab to cell G4 on the week 36 tab.

Thanks again for all of your help!
Jake

**NBVC** · 01-11-2012, 04:07 PM

Try:

=SUMIFS('Payment Sheet'!C:C,'Payment Sheet'!$A:$A,$A4,'Payment Sheet'!$B:$B,G$3)

copied down.. if you want to collect from column D, E, etc... then copy across too.

**Txquadrider** · 01-11-2012, 04:22 PM

WOW you are a true life saver!!! I just checked it agaist my reports and so far have not found anything wrong with it!

I cannot thank you enough for your help! You did in 5 mins what I have been looking at for two days!