If you have not used vlookup, give it a shot! It is my (as well as many others!) favorite Excel function. I use vlookup almost daily. The format is…
=VLOOKUP(a1,a13:N20,2,FALSE)
This function looks for what is in cell a1, in a13:a20. if it finds an exact match, it returns what is in cloumn 2 of the a:n table (in this case column b). The false is the switch to tell it to find an exact match, if you leave off false you will get the closest match.
You can find a list of all Excel Functions at ExcelYogi.com
Now…Go try it!
***Updated***
Excel Yogi has created the new VlookupPlus add in. Read more about it here:
Vlookup Add in
Related posts:
- Vlookup Multiple Criteria in Excel The standard vlookup function allows for one condition to be...
- Multiple Condition Vlookup Function Add-in - Excel The question we are asked most often by ExcelYogi readers...
- Vlookup the Last Occurence of an Item - Excel The title of this post is slightly misleading. We will...
- Excel Function “AND” AND function use...
- Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...