[Affiliate]
Blog Stats
- 2,994,185 hits
-
Join 3,848 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to replace value with a value from another column in Power Query
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Insert a text string into a specific position of another text string in #Excel
- Open an embedded Excel file during a slide show in PowerPoint?
- Perform VLOOKUP with 2 lookup values
- Copy values from Status Bar in #Excel 365
- Rename column names in a dynamic way with #Excel #PowerQuery
My YouTube Channel
My Facebook page
- My Tweets
Search Results for: VLOOKUP
#PowerQuery makes advanced VLOOKUP so easy!
Do you use VLOOKUP? If you do, you should know there are limitations to VLOOKUP. Also, there are some cases VLOOKUP is not straightforward and efficient. Consider the following cases: What we want to achieve is to map the corresponding … Continue reading
VLOOKUP the Nth matched item, with helper column
This should be the last post in 2015. So it’s better to answer unanswered question in the year. 🙂 Question: “VLOOKUP will return the first matched value found, in case there are multiple matched records what formula should we use?” This … Continue reading
Nested IF vs. VLOOKUP – Which one to use?
A well-drawn flowchart or a well-organized table helps you write a successful formula effectively Continue reading
HLOOKUP – The less-know sibling of VLOOKUP
Many people talk about VLOOKUP and agree that it is one of the most useful functions in their work life with Excel. However, if you ask them about HLOOKUP, maybe 30% of them have no idea of its existence. The Google search … Continue reading
Perform VLOOKUP with 2 lookup values
4 different ways to perform LOOKUP with 2 lookup values We know that VLOOKUP is very useful. At the same time, we know that VLOOKUP has its limitations. E.g. VLOOKUP only looks from left to right; VLOOKUP only handle one … Continue reading
3D VLOOKUP – Perform VLOOKUP from more than one table
Pls have your 3D glasses ready… only if you are going to watch a 3D movie. You don’t need it for a 3D VLOOKUP. We talked about how to do a 2D VLOOKUP by using MATCH together with VLOOKUP. With that … Continue reading
Alternative to vlookup – Index and Match
Lookup from Right to Left In the above example, if it is given the Student ID, it would be so easy to find one’s corresponding Name and Grade by using vlookup. However, if we would need to find out the … Continue reading
Advanced vlookup – wildcard characters “?” and “*”
Why vlookup gives me wrong answer??? Bugs in vlookup??? I am sure it’s not about text vs. number, but it still fails to give the correct answer!!! I guess many users are not aware of the wildcard characters in Excel. … Continue reading
Advanced vlookup – Text vs. Number
Why does vlookup not return the lookup value? I am sure it is in the source data table. I see it by my eyes. Have you ever experienced this?? That’s normal when you import your data from other database. Fortunately … Continue reading
vlookup – True or False??
Usually we use vlookup for answering a particular question like “How many customers we had on January 1st 2014?” We expect an exact match and hence using FALSE as the last argument in the vlookup formula. When do we use … Continue reading
vlookup with Match
Hard-coding the col_index_num in the vlookup formula is not a wise choice as you might have to look into the formula and make changes every time you copy and paste your formula. An alternative approach of marking column index on … Continue reading
Tips in constructing vlookup
Tips in constructing vlookup We talked about the syntax of vlookup and we had written a vlookup formula successfully in the previous post. YEAH! Now we want to ride on the formula by copying it DOWN and to the RIGHT … Continue reading
The basic of vlookup
vlookup – Something you should know about The basic of vlookup Definition of LOOKUP (http://www.merriam-webster.com/dictionary/lookup) : the process or an instance of looking something up;especially: the process of matching by computer the words of a text with material stored in memory v, in the … Continue reading
Fixing inconsistent data type in lookup table in #Excel
A common VLOOKUP problem with an easy fix The situation – VLOOKUP fails… Have you ever encountered something like this? This is quite common. We are sure that the VLOOKUP formula is correct. We are sure that the lookup values … Continue reading
The Power BI Journey
Note: This is not a “how-to” post. In this article, I share my thoughts on how people start their Power BI journey, based on my observation and imagination. 😁 When you say you want to learn Power BI, what do … Continue reading
Have you encountered any weird formula in #Excel?
Happy Halloween! 👻 Let’s do something fun. You are invited to leave your comments below. For what? For sharing with us any “weird” formula that you have ever seen in Excel. Real cases please. 😁 Wait… what do I mean … Continue reading
#Excel Power Query solves a real life problem – Who eats what?
Interesting application of Power Query for real life problem – See how to transform table into different layout using Power Query I came across this Power Query Challenge from Computergaga and I found it really interesting as it seems that … Continue reading
Posted in Power Query
Tagged Conditional Column, Demote Headers, Merge Query, Pivot Column, Transpose Table, Unpivot column
7 Comments
Be cautious when using XLOOKUP
Can you spot the error in the above formula? It’s not about the new function of XLOOKUP. It’s about inevitable human error… If you are an Excel fan, you should be aware of the exciting XLOOKUP function in Office 365. … Continue reading
Suggestion: Adding a button for number formats in thousand/million/billion in #Excel
Did you know what you may submit your ideas to improve Excel through UserVoice? The recent HOT news in the Excel community – the new XLOOKUP function is also resulted from an idea submitted in UserVoice. While everyone is super exciting … Continue reading
Hard-coded range expands automatically with #Excel Table
The INDIRECT trick of using Structured Reference in Conditional Formatting Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading