Good day,
I have the below function and it works 100%. I have now discovered that when there is a blank cell in the lookup the formula does not work. I would appreciate if any one could help me with the formula to ignore when it comes across a blank.
I have the below function and it works 100%. I have now discovered that when there is a blank cell in the lookup the formula does not work. I would appreciate if any one could help me with the formula to ignore when it comes across a blank.
Code:
=INDEX(Sheet6!$E$10:$F$90,MATCH(LOOKUP(3,1/SEARCH(Sheet6!$E$10:$E$90,A2),Sheet6!$E$10:$E$90),Sheet6!$E$10:$E$90,0),2)