How To Update And Fix Your Vlookup And Index Match Formulas

Показать описание

In this video I share a few bug fixes and updates to VLOOKUP Assistant. This includes INDEX & MATCH to the Left, and using the COLUMNS function in the VLOOKUP column index number argument.

I'm happy to hear that you are excited about this tool and will find it helpful in speeding up your work. Please feel free to share it with your co-workers and friends. Thanks again! 🙂
00:00 Introduction
01:44 Index Match
02:32 Columns Function
03:40 Index Match to Left

Рекомендации по теме

Комментарии

Mr. Jon, you are super. What a insight! Thanks,

esthersuh

Thank you Jon, if you just mention the difference between INDEX MATCH & VLOOKUP, I will be very thankful.
Thanks in advance👍

naifal-amodi

This is awesome. Super helpful and will save a lot of time for tedious lookup tasks. THANK YOU!

vidyaram

Hi Jon.. awesome.. love the new additions. Also, after tinkering with it, I think your use of Application.InputBox is a better choice than a user form. In a way, it mimics the step logic when using the actual function, so is more familiar or natural than a form with everything on it. So, I think you made the right choice with the InputBox interface vs. a User Form. Thanks again for this excellent tool and the great ideas to automate and simplify more complex processes. Thumbs up!

wayneedmondson

Hi there! I just got turned onto your excel videos because I use vlookup for my job but lately Ive been running into a snag. And was wondering if you could help? Your examples however arent relatable to how I use vlookup.
I want to have #N/As- those signify NEW JOBS. But I'm getting an error that says, this column has more than 10, 000 unique items. Only the furst 10, 000 unique items are displayed.
I will need vlookup to match around 18, 000.
Please help.

sweetpea_socal.

Thankyou very much for this tool. Can you please instruct how I would change the VBA code so that the index match is case sensitive?
I'm trying to apply this concept to the code but not sure how:
{=INDEX(data, MATCH(TRUE, EXACT(val, lookup_col), 0), col_num)}
Case 3
sFormula = "=INDEX(" & sReturnArray & ", " & "MATCH(" & sLookupValue & ", " & sLookupArray & ", 0))"

HLDENSUX

Can I add this on my pc home, if so how do I install it. Thanks!

simoiyahector-morales

How To Update And Fix Your Vlookup And Index Match Formulas

Fix 'Your device is missing important security and quality fixes' Error in Windows PC

Fix Any Windows Update Error on Windows 10/Windows 11

Delta | How to fix 'Roblox Upgrade' Error (BEST TUTORIAL 2023)

How to FIX PS4 Won't Update System Software (Easy Method!)

Fix unable to install update an error occurred installing ios 15.2 | iPhone

iPhone Not Updating? Here's The Real Fix!

How to Fix Windows 11 Update Errors? Update Failed Error

Fix windows 7 update error 80072efe | Error Code 80072EFE Problem Fixed

How to Fix Windows 11 Update Error [ Easy & Best Solution ]

How to Fix Update Apple ID Settings Stuck on iPhone/iPad iOS 16/17

The Ultimate Guide to Fix Windows 7 Update Issues (2024 Edition)

Fix your device is missing important security and quality fixes windows 10 | Problem Solved

Fix something went wrong try to reopen settings later windows update | Problem Solved

💥🚗FINALLY NEW!! TRUCKERS OF EUROPE 3 - HOT FIX UPDATES v0.47.3

How To Manually Install or Fix Windows Updates

The Samsung Universal Fix For ANY Issue After ANY Update! - An Advanced Users Trick

How To Fix Any & All Issues After You Update Your Samsung

FIX All Windows UPDATE Problems and Make FASTER in Windows 11/10

How to Fix Slow Performance Issue After Update On Windows 11/10 (2022)

How to Fix a Windows Update Pending Install (Solved)

My iPad Won't Update! Here's The Fix.

How to Fix Windows Update Installing Stuck on 0% in Windows 10

FIX Windows Update Error 0x80070643 on Windows 10

How to FIX A Stuck Windows 10 Update