How to Use the IF Function and the VLOOKUP Function Together In Excel?

Asked by Last Modified  

Follow 2
Answer

Please enter your answer

Training Centre

Any funcitons can be mixed and matched. IF is used for condition.Example:=IF(A1>10,VLOOKUP(), "")=VLOOKUP(IF(A1=10,SUM(), VLOOKUP())
1 Comments

Microsoft Certified Excel Specialist & Power BI Tutor with 15+ yr Corporate & Personal Training Exp

There are many ways. =Vlookup(if(A1="",B1,A1),array,column_index_number,0) This will lookup value in column B if column A cell is empty.
Comments

Microsoft Certified Excel Specialist & Power BI Tutor with 15+ yr Corporate & Personal Training Exp

=Vlookup(A1,C:D,if(A1="X",1,2),0) Here A1 value is lookup in column array C:D and result from first column of array (Column C) is provided if A1 value is equal to "X" or result from second column of array (Column D) is provided if A1 value is not equal to "X".
Comments

View 1 more Answers

Related Questions

How can I create a letter head on excel?
Select a cell for typing the Title, change the font size in Formatting tool bar, merge cells in formatting tool bar depending on the length of title.
Jitendra
Is it necessary to have the knowledge of VB script for Excel Macro Training?
Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more....
Suma K V
what is the recommended time needed to learn excel and cost ?
Excel is one of the tools that is most widely used by people all over the world, As others have said, it is a very vast topic, but the basics can be learnt in 10-15 hours. And there are many additions...
Hemant
What are the 5 most essential excel tools to master?
tools? Is that right, is that what you wanna know? there is no such thing as tools inbuilt in excel. Tools are specifically designed for a set of people or a company for a specific purpose to be added...
Yashraj
0 0
6
What is exact number of days required to learn basic & advanced excel?
10-15 days sufficient but you need practice on that.
Anusha

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Excel Shortcuts
ShortCut Key Description F2 Edit the selected cell. F3 After a name has been created, F3 will paste names. F4 Repeat last action. For example, if you changed the color of text...

Common MS Excel Shortcuts to make life easier!
Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...
S

Shruti S.

0 0
0

VBA Function - INSTR
INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

Hidden Gems Of MS Excel - Consolidate
Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you