N
NewPlayer
Hi there, I would like some help please.
I have a template where columns B1 to G1 are names of Certain Customers.
And the rows from A3 to A50 are list of Group Expenses, i.e. Marketing,
Advertising etc.
On another sheet where I downloaded to a csv file are lists of Customers (
at the Columns ) and list of expenses with subtotals of Group of expenses
(rows). Customers can be few or sometimes up to 30 ( but I only wanted a
few Certain Customers ), and the rows of expenses are not the same monthly,
rows could increase or decrease but the sub-totals of Group of Expenses will
always be there.
Question: How do I write a if and lookup formula , to look up the Certain
Customers and then go down to the Sub-total of the expenses and put the
amount there.
Hope I made myself clear.
Thanks
NewPlayer
I have a template where columns B1 to G1 are names of Certain Customers.
And the rows from A3 to A50 are list of Group Expenses, i.e. Marketing,
Advertising etc.
On another sheet where I downloaded to a csv file are lists of Customers (
at the Columns ) and list of expenses with subtotals of Group of expenses
(rows). Customers can be few or sometimes up to 30 ( but I only wanted a
few Certain Customers ), and the rows of expenses are not the same monthly,
rows could increase or decrease but the sub-totals of Group of Expenses will
always be there.
Question: How do I write a if and lookup formula , to look up the Certain
Customers and then go down to the Sub-total of the expenses and put the
amount there.
Hope I made myself clear.
Thanks
NewPlayer