In this article, we will learn how to use ISERROR function along with Vlookup function to ignore the error as result in Microsoft Excel.
If we merge the VLOOKUP and MATCH functions together, we can create our own custom formula, which will work as a two-way lookup formula that enables us to easily cross check two fields of information in the table.
Let’s take an example and understand how we can use Match function along with Vlookup function and how it works?
We have car sales data in which we have used Data Validation in cell A15 for Cities & in cell B14 for Sales Person.
In Cell B15, the Vlookup function is used with the Match function to return the number of Car Sales for ‘Steve’ in ‘Alabama’ City using fixed Index number as 2. With a combination of Vlookup and Match Formulae, the Vlookup formula works dynamically.
Follow below given steps:
Whenever you will change the city name and sales name, formula will pick the number accordingly from the data.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.