[Affiliate]
Blog Stats
- 3,316,202 hits
-
Join 3,247 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)
- Highlight weekends and holidays using Conditional Formatting in #Excel
- F8 - It is for selecting range(s) of cells
- Quick Tip - Edit #DAX formula in #PowerBI Desktop efficiently
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- #Excel Add current selection to filter. What it does?
- Highlight differences in two ranges with Conditional Formatting in #Excel
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Do you know Menu Key??
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: XLOOKUP
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
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
wmfexcel 