LOOKUP functions in Excel 2010 made easy!

We have written about VLOOKUP earlier but this is not restricted just to the VLOOKUP. There are other LOOKUP functions in Excel 2010 that you need to understand better too. LOOKUP functions help you play with your data and fetch the results that you need easily. This is why these LOOKUP functions are important for you and you need to master them.

What do you know about these functions? Don’t worry, if you don’t know much about them, we can help you. Here are the LOOKUP functions in Excel 2010 made easy for you. A LOOKUP function searches for a value in a given range and gives you a corresponding value from the same range. Consider this example, if there’s a table with names, age, and sex, you can search for the name and retrieve the age or sex of that person.

Apart from the LOOKUP functions, you also need to know about the MATCH and OFFSET functions. These functions work similar to LOOKUP function and you can use them when LOOKUP function won’t work with the data that you have.