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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()