Returning a Value when two separate conditions are met.

[andresndor]

Hello.

Every month I get a report that has multiple expenses and a payment. Once the payment is made I will enter the report name in Column E which should match to the charges for the month.
What I would like to do is use a formula that will take the value in Column A that corresponds to the payment (this will always be “Configuration Hidden”) and return a value in Column F of “Paid” or “Unpaid” for all of the expense line items.

Any suggestions?

[Richard Buttrey]

Hi,

Would you manually add examples of the results you expect to see. I'm struggling to understand what you actually want.

[andresndor]

Thanks for your reply, Richard.

I have added a finished version of what I am looking for to the right of the original information.
What I would like to be able to do is manually add a report name anytime there is an occurrence of the words “Configuration Hidden” in Column N. The formula would then look through the table and any time there is an occurrence of the same report name “Paid” would be entered for exact matches and “Unpaid” when there isn’t a match and “-“ the lines containing “Configuration Hidden”.
As you can see in the updated example a payment was made for $-3,926.88 and all of the charges from the same report net to zero and are marked paid.

Hopefully this is easier to understand than the previous example.

[Richard Buttrey]

Hi

Is there only ever one IDC number in column E?

[andresndor]

Typically the report names would change from month to month. So the next report for this individual would be IDC093015 then IDC103115 etc.

[Richard Buttrey]

Hi,

Perhaps I phrased it badly but that wasn't what I was asking. However I think your answer confirms that there will only be one unique IDC number and that you'd never have say both the IDC numbers you've just mentioned ON THE SAME REPORT

In which case in F2 copied down

Please Login or Register  to view this content.

[andresndor]

Sorry Richard, that didn't really answer your question. It seams that there would have to be at least two occurrences of the same name in Column E (a purchase and its corresponding payment).

[andresndor]

Is there anyway that we could replace IDC with the cell # ? The first three letters are the initials of the employee and we have about 40 people putting through reports each month. Sorry for the confusion but now your question makes more sense.