I have a question when it comes to looking up a value on a pivot table based on two criteria. I've searched this and other forums but no formula seems to be working for(nor does any macro or coding).
I need to be able to look up the daily usage amount for an account based on the account and date. The daily usage is in a pivot table where the dates are going across and the accounts are going down(x&y basically). I've tried index match functions, getpivotdata, vlookups and hlookups. They seem to return the wrong data. I also need to multiply the daily usage by the price up top but that i know can be done simply afterwards so if you could at least help in finding a formula that gives me the correct data for each cell it would be greatly appreciated.
Thanks!
Bookmarks