close
I have a ranking sheet and have determined who moved forwards based on this
weeks/last weeks position using large,cellrange,1 but when using lookup to
put a name to number it returns a person with 0 value, by omitting this
person i can get the result that i want, but how do i get lookup to ignore 0
values?
=if(vlookup(a,b,c)=0,quot;quot;,vlookup(a,b,c))--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=524763
全站熱搜