vlookup multiple criteria

[commoguy_2010]

Hello everyone,

I am working on my personal budget and have hit a snag along the way.

I am presented with a user form to enter payment data. From there the payment data is placed on a separate sheet (Payments). The payments sheet holds the item, amount paid, date paid and the confirmation number.

I also have a third sheet (2016 (for the year)) In this sheet the columns are the months of the year and each row starts with an item (Car, Insurance, Phone etc...)

My goal here is to lookup the values of the Payments sheet for certain criteria. Example - If there is a payment entered for "Car" in the month of "Jan" then I want the amount paid to populate in my (2016) sheet under JAN & Car.

Any help offered is greatly appreciated!

[southward]

Hi,

Something like this should work for you.

Please Login or Register  to view this content.

Hope this is helpful.

Cheers

[commoguy_2010]

Thank you so much!

This works perfect in the JAN column. However, how would I get this to go to the FEB, MAR, etc... columns? I changed the formula to this:
=IFERROR(INDEX(PAYMENTS!$B$8:$B$20,MATCH($A5,PAYMENTS!$A$8:$A$20,0),MATCH(C$2,PAYMENTS!$C$8:$C$20,0)),"") to move to the next month but the payment still populates in January's column.

Thanks for your help!

[TudyBTH]

Hi,
use this formula in B3 and drag down and to right

Please Login or Register  to view this content.

see atached