Vlookup two variables

1. Vlookup two variables

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

2. Re: Vlookup two variables

Can you pls tell us which is the expected result in F8 and why?

3. Re: Vlookup two variables

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.

4. Re: Vlookup two variables

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)),"")

5. Re: Vlookup two variables

That works however I need it to look up the description "Plant & Equipment" too.

6. Re: Vlookup two variables

=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.

7. Re: Vlookup two variables

Perfect Thanks!

8. Re: Vlookup two variables

......................

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1