by Crispo Mwangi | Nov 24, 2022 | INTERMEDIATE EXCEL
Of all lookup functions, HLOOKUP is among the least famous ones. It looks up a value in the first row and returns any corresponding item in another row. Look up value MUST be in the top row of a table. How do you make it return multiple items? It’s default...
by Crispo Mwangi | Nov 16, 2022 | INTERMEDIATE EXCEL
VLOOKUP function is mostly underrated and assumed that it cannot return multiple items. The only trick is to use row numbers as lookup values…VLOOKUP can loop through numbers one at a time and return corresponding values. =VLOOKUP(...
by Crispo Mwangi | Nov 9, 2022 | BASIC EXCEL
Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...
by Crispo Mwangi | Nov 4, 2022 | BASIC EXCEL
When testing for multiple conditions, OR logic is used to determine if ANY condition in the test is TRUE. The only time OR function evaluates to FALSE is if all conditions in a test are false =OR( 2>5, 6>5 ) will evaluate to TRUE though the first logical test...
Recent Comments