How to combine different formulas

[Cime14]

Hi team!

Is it possible to combine two formulas like below ones into one single formula?

F1: =+IF($C$1="Jan";$B$27;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$27)

F2:=+IF($C$1="Jan";$B$55;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$55)

Thank you in advance!!

 

[Joe4]

Re: How to comibine different formulas

I think you are going to need to explain the logic first.
Both IF statements are checking the same thing, so it is not clear how it should be combined.
Maybe explain exactly what you are trying to do (in plain English).

 

[Cime14]

Re: How to comibine different formulas

It is really difficult to explain without sending you excel file to see.
If you are prepared to help I can send file to your e-mail and explain a little bit what I am trying to do
If so please let me know your email address.

Thanks!!

 

[Joe4]

Re: How to comibine different formulas

If you are prepared to help I can send file to your e-mail and explain a little bit what I am trying to do

I am sorry, that is not something that I typically give out. I cannot download/receive files from my current location anyway (workplace security forbids it).

Though you cannot upload files to this site, there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Cime14]

Re: How to comibine different formulas

Actualy I have to merge two formulas into one.
Is it possible to merge two vlookup formula?
F1: =VLOOKUP(Months!$L2;'ACT BI 2017'!$D$6:$CR$24;Months!$I$2;0)
F2: =VLOOKUP(Months!$L2;'ACT BI 2017'!$D$6:$CR$24;Months!$I$3;0)

Both are connected to drop-down menu and when change it value should be updated. For instance I have 12 month and 7 companies. I would like to have a table with values displayed based on selected drop-down option.

 

[Joe4]

Re: How to comibine different formulas

Do you mean that you just want to combine the results in a single cell?
If so, use CONCATENATE or &, i.e.

[COLOR=#333333]=VLOOKUP(Months!$L2;'ACT BI 2017'!$D$6:$CR$24;Months!$I$2;0) & " " & [/COLOR][COLOR=#333333]VLOOKUP(Months!$L2;'ACT BI 2017'!$D$6:$CR$24;Months!$I$3;0)[/COLOR]

 

[Cime14]

Re: How to comibine different formulas

Thanks for sending me the code but it is not the one I am looking for.
As mentioned I would like to use two drop-downs. One for months and one for company.
At the moment I have two vlookups which are showing me the right values. One for months and one for companies. Now I would like to combine those two into one formula.

For example: If I choose from drop-downs month FEBRUARY and company B to show me respective result in a selected cell.

 

[Joe4]

Re: How to comibine different formulas

So are you saying that you need a VLOOKUP that matches on TWO conditions?
If so, you cannot use VLOOKUP to do that. VLOOKUP can only match on one condition.
One workaround people often do is to use a "helper" column, where they combine the two values that they want to match on in a single cell. Then do the VLOOKUP on that combined two values.
See here for an example of that: https://exceljet.net/formula/vlookup-with-multiple-critiera

Otherwise, you will have to use other formulas. Here show some other options:
http://dailydoseofexcel.com/archives/2009/04/21/vlookup-on-two-columns/
https://www.excel-university.com/vlookup-on-two-or-more-criteria-columns/