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

I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.

As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like -...
Francis
0 0
5
Can you help with this Excel formula?
What exactly you want??? I can help you .
Sajjan
0 0
5
Is MS Excel very easy to learn?
Yes it is easy application to learn
Kamal
0 0
6
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7
Why do we use a dollar sign in Excel?
A dollar sign $ is called a locked cell reference. Locked cell references are one of the building blocks of Excel modeling. Without them, you will waste endless amounts of time re-writing formulas.
Poonam
0 0
8

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

Ask a Question

Related Lessons

MS Excel Tips
If you want to do a save as on MS Excel Workbook, use the shortcut key F12 and then select the location and click save
R

Hidden Gems Of MS Excel - Auto Fill: Only Weekdays OR Only Months OR Only Years
Fill dates Automatically in worksheet cells. The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known. 3rd format - Only Weekdays 4th format - Only Months* 5th...

Today WE LEARN a excel formula like UPPER FUNCTION
Here we are using upper case formula, these formula are used in advanced excel. A B C 1 Hansraj HANSRAJ =upper(TEXT) =UPPER(B1) 2 lakir LAKIR =UPPER(B2) 3 Seema SEEMA =UPPER(B3) 4 Mansi MANSI =UPPER(B4) 5 jyoti JYOTI =UPPER(B5) 6 mahima MAHIMA =UPPER(B6) 7 shashi SHASHI =UPPER(B7) ...

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

An Introduction to Business Intelligence Concepts
Looking for a Business Intelligence (BI) solution for your company can be intimidating. BI uses its own special terminology and the database design concepts can be difficult to grasp. So where do you...

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