How about this one?
=IF(SUBSTITUTE(A1," ","")+0>LOOKUP(1E+100,SUBSTITUTE($F$2:$F$14," ","")+0),"N/A",LOOKUP(SUBSTITUTE(A1," ","")+0,SUBSTITUTE($E$2:$E$14," ","")+0,$G$2:$G$14))
How about this one?
=IF(SUBSTITUTE(A1," ","")+0>LOOKUP(1E+100,SUBSTITUTE($F$2:$F$14," ","")+0),"N/A",LOOKUP(SUBSTITUTE(A1," ","")+0,SUBSTITUTE($E$2:$E$14," ","")+0,$G$2:$G$14))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks