HI,
I am trying to plot a value within a cashflow based on two descriptions - a month (number) and description (text). I have tried a formula in cell F8 in the "Asset Base & Capex" sheet.
Any ideas would be greatly apprecaited.
PERE
HI,
I am trying to plot a value within a cashflow based on two descriptions - a month (number) and description (text). I have tried a formula in cell F8 in the "Asset Base & Capex" sheet.
Any ideas would be greatly apprecaited.
PERE
Can you pls tell us which is the expected result in F8 and why?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
My goal is to have the Capex amount move anywhere along row 8 based on a reference to "Plant & Equipment" and the relevant Month. I.e. if F8 looksup Plant & Equipment in the "Assumptions" sheet, it will look at the month the payment is to occur i.e. month 10 and the amount i.e. $500,000. If you change the month or the amount, my goal is to have row 8 (in "Asset Base & Capex" sheet) plot the value automatically.
In F8 and copy across??
=IFERROR(INDEX(Assumptions!$C$4:$C$10,MATCH($A$5,Assumptions!$A$4:$A$10,0),MATCH(F$2,Assumptions!$B$4:$B$10,0)),"")
That works however I need it to look up the description "Plant & Equipment" too.
=IFERROR(INDEX(Assumptions!$C$4:$C$10,MATCH($A$5,Assumptions!$A$4:$A$10,0),MATCH(F$2,Assumptions!$B$4:$B$10,0)),"")
The red part of the formula does this.
Perfect Thanks!
......................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks