Populating mutiple cells based on specific values

Hey Folks

Attached a sample of the spreadsheet that I am working with.

Colum A records a PIN
Colum B records Payment Method
Colum C records a value

What I need is a formula that will populate Colum F with a PIN and Colum G with the associated value for that PIN if the payment method is Payroll.

I dont know why I cant figure this out, everything I try isnt working.


Thanks in advance.

hi Grillpan
hope you are looking for this sol.
please find attached file.


cheers.


if satisfied then mark this thread solved and click the star below .
thanks

Put this formula in D3:

Formula:

Please Login or Register  to view this content.

then copy down. Put this formula in F3:

Formula:

Please Login or Register  to view this content.

and this one in G3:

Formula:

Please Login or Register  to view this content.

Format G3 as currency with 2 dp, then copy F3:G3 down until you get blanks.

Hope this helps.

Pete

Thank sguys, went with Benishiryo's version but each one worked really well but all of you have helped me to understand where I was going wrong.