I feel comfortable using vlookup, you might prefer index and match combo.

It makes you to connect two different tabular lists and saves a ton of time.

In my opinion understanding VLOOKUP, INDEX and MATCH worksheet formulas can transform you from normal excel user to a data processing beast.

Imagine you have all your customer contact information in one sheet in the range A1:D5000 in the format phone number, name, city and date of birth.

Now you need to find out which customer has the phone number 936-174-5910.

VLOOKUP is one of the formulas you can use to answer questions like this.

Since MATCH() function can tell us where the data is found, you can then use INDEX() function to extract corresponding data from another column.

In this case, we can use MATCH() to find out which row has net sales 1,799 and INDEX() to return the name of the person.

If you want to stop seeing the error, use IFERROR function.

But this book will open your eyes to some brilliant techniques.

I do this by sharing videos, tips, examples and downloads on this website.

There are more than 1,000 pages with all things Excel, Power BI, Dashboards VBA here.

VLOOKUP: vertical look up i.e.

HLOOKUP: horizintal look up i.e.

Columns.

Also, very useful in auditing and linking the data to take a business decision.

Its almost easier to simply move the key in a large data table all the way to left and just do a vlookup.

I find a lot of times I need to use it when I know the item might not be in the list.

As mentioned above, if the item isnt there, you get a NA, which keeps you from summing or doing anything else useful with the collected information youve built.

If it returns an error the ISERROR is true, so it puts a zero in the cell.

If the first VLOOKUP returns a value, it runs the VLOOKUP again and puts the value in the cell.

Ive put in strings like No that I use to sort the info later, etc.

Ive used it in some very large project planning workbooks, commision calculations for sales, as well as a couple of different financial models and never had a problem with it slowing down Excel.

I deliberately left out hlookup(), index() few other formulas as I wanted to keep this post short and digestible.

I agree that hlookup is as useful as vlookup and you should choose these functions based on the situation.

Ms Excel 2007 Formulas In Urdu Pdf