Hello people,
I've been searching in this forum but I cannot seem to find any answer,
I know I can use the if() function. but that will mean a long formula string. I'm looking for a way to use hlookup to find a given number within a range. Then do the corresponding formula based on that range the given number is within..
Any Ideas??
I've been searching in this forum but I cannot seem to find any answer,
I know I can use the if() function. but that will mean a long formula string. I'm looking for a way to use hlookup to find a given number within a range. Then do the corresponding formula based on that range the given number is within..
Any Ideas??