Question description:
This user has given permission to use the problem statement for this
blog.
In which scenario we will use the if function combined with v lookup function?
Solved by O. J. in 23 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/05/2018 - 09:44
Hi, Thank you for using Got It Pro.
I’m happy to be able to help you today.
User
16/05/2018 - 09:45
Hello
Excelchat Expert
16/05/2018 - 09:45
How can I help you?
Excelchat Expert
16/05/2018 - 09:45
Is there a specific task that you need help on
Excelchat Expert
16/05/2018 - 09:45
or is it just this general question
User
16/05/2018 - 09:46
In which scenario, we will use if function combined with Vlookup function?
Excelchat Expert
16/05/2018 - 09:46
there are multiple scenarios
User
16/05/2018 - 09:47
Give me an example
Excelchat Expert
16/05/2018 - 09:47
you could use the if function to change the lookup array
User
16/05/2018 - 09:49
Please go ahead
User
16/05/2018 - 09:49
with your example
Excelchat Expert
16/05/2018 - 09:51
okay in this example
Excelchat Expert
16/05/2018 - 09:52
if you check the formula in B4
Excelchat Expert
16/05/2018 - 09:52
The if function changes which table the vlookup function uses
Excelchat Expert
16/05/2018 - 09:52
so if the name is John it uses the table in range D2:E4
User
16/05/2018 - 09:52
Please mention the formula
Excelchat Expert
16/05/2018 - 09:52
otherwise if uses the table in G2:H4
Excelchat Expert
16/05/2018 - 09:52
=VLOOKUP(B3,IF(B2="John",D2:E4,G2:H4),2,0)
User
16/05/2018 - 09:54
Ok
Excelchat Expert
16/05/2018 - 09:55
Is there anything else I can help you with regarding this matter?
User
16/05/2018 - 09:57
In the excel, b2 is Tom know, then how could you mention b2="john"in the formula
User
16/05/2018 - 09:57
And you got the tom's gas expenses as 30
Excelchat Expert
16/05/2018 - 09:57
Yes because the formula checks if the value is john
Excelchat Expert
16/05/2018 - 09:58
if it is john then it uses the table of john
Excelchat Expert
16/05/2018 - 09:58
Any other result will use the table of Tom
Excelchat Expert
16/05/2018 - 09:58
So if the name is not john
Excelchat Expert
16/05/2018 - 09:58
it will use the other table
User
16/05/2018 - 09:58
Alright
Excelchat Expert
16/05/2018 - 09:59
When you are done with the session please click on end session.
Have a great day ahead :)
User
16/05/2018 - 09:59
This is the basic example, right?
Excelchat Expert
16/05/2018 - 09:59
there are lots of examples
User
16/05/2018 - 09:59
we can use it complex issue as well, is it correct?
Excelchat Expert
16/05/2018 - 09:59
the sky is the limit
Excelchat Expert
16/05/2018 - 09:59
yes of course
User
16/05/2018 - 10:00
Tq for the explanation
Excelchat Expert
16/05/2018 - 10:00
My pleasure
Excelchat Expert
16/05/2018 - 10:01
When you are done with the session please click on end session.
Have a great day ahead :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
