Purpose
Vlookup can only perform a vertical lookup.
By nesting these two functions we can perform a vertical and horizontal lookup at the same time.
Workinstruction
The instructions apply to the file that you can download here.
Match
Returns the relative position of an item in an array. Use MATCH instead of one of the LOOKUP functions when [...]
Thanks to the contribution of Zoltan Till, I was able to update the Function Translation file with the Hungarian translations.
His contribution is much appreciated, and I sincerly hope some of you will benefit from it.
You can download it here. translator1
Cheers,
Stefaan
Hi,
First day of the month
In this example the assumption is that you already know the funtions : Date, Year, Month
In order to calculate the first day of the month we need to combine Date, Year and Month.
The cell A1 contains the current date.
Year and month will extract the year and month of the current date.
The [...]
Hi all,
In Microsoft Excel the names of functions depend on the language of the installed version of MS-Office.
It can be quite a pain to find out what’s the translation of a particular function in your language. For example if you’re used to the English functions and have to work in another language.
I have developed a [...]
This workbook contains 157 worksheets, each explaining the purpose and usage of particular Excel functions.
There are also a number of sample worksheets which are simple models of common applications, such as Timesheet and Date Calculations.
Author : Peter Noneley
Excel Function Dictionary
Using the function wizard is often very time consuming…here’s a shortcut I use all the time.
Write the equal sign and then the name of the function
e.g. =vlookup
Press and hold CRTL and press a (CTRL-A)
There you are.
Tip: try the same, but use CTRL-SHIFT-A