Quote:
Originally Posted by Will
Hi,
I was searching on-line for some help on the Find formula, and came across this. Would someone be able to explain it?
=LOOKUP(REPT("z",255),CHOOSE({1,2},"ANOTHER VALUE",LOOKUP(1000,FIND($E$1:$E$10,A1),$E$1:$E$10) ))
|
This is a bad formula (see my previous post).
Try this one, it's simple and more reliable:
=(IF(ISERROR(MATCH(A1,$E$1:$E$10,0)),"Another Value",A1))
Bruno