Hi all
I have another curly formula for one of you genius’ out there.
The outcome needs to be placed in column AD of the “PAYMENT” (tab name), commencing at Cell Reference AD2. I need to convert various criteria matches within the “PAYMENT” (tab name) to equal a $dollar payment based on the table in “ARRAYS” (tab name). The criteria to be matched is located in columns P through to R then using the amount specified in Column S of the same sheet. (This information can be modified to suit any match/lookup etc. required it if makes it easier for a formula.)
By matching each line with outcomes displayed in “PAYMENT” (tab name)
column F-Fund, and
Column N-Level, and
Column AC-PRE or POST,
then using the matched data in “ARRAYS” (tab name) multiply the outcome in Column AA of the “PAYMENT” (tab name) by the $ value in column S of the ARRAY.
So the query is look for a match in “PAYMENT” (tab name) columns F, N and AC against the Array Table in “ARRAY” (tab name), and where it matches, multiply the dollar amount in the “ARRAY” (tab name) in column S by the figure in AA of the “PAYMENT” (tab name).
If no match found, answer “0”
It is a bit difficult considering the POST information currently equals Zero, and does not apply until after 01 July, but I’m sure the formula you come up with will work.
AND thanks to feedback from Rylo - very much appreciated my friend, I've reduced the number of lines/data and provided what I think the outcome should be.
Thanks in advance.
Regards Chris
Bookmarks