Tag Archives: range
TEA BREAK WITH EXCEL: ALTERNATIVE TO VLOOKUP/HLOOKUP, INDEX(MATCH())
TEA RATING: ☕
If you are struggling to query your date in an excel sheet, you can use index(match()) formula to lookup. Unlike vlookup or hlookup, index(match()) is more flexible and more roboust.
Continue reading TEA BREAK WITH EXCEL: ALTERNATIVE TO VLOOKUP/HLOOKUP, INDEX(MATCH())TEA BREAK WITH EXCEL: FINDING A SPECIFIC TEXT IN A CELL RANGE (OR IF THIS TEXT IS INCLUDED IN THIS RANGE OR NOT?)
Tea Rating: ☕
To find a specific text in a specific range we are using the formula;
Continue reading TEA BREAK WITH EXCEL: FINDING A SPECIFIC TEXT IN A CELL RANGE (OR IF THIS TEXT IS INCLUDED IN THIS RANGE OR NOT?)