Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A B c D (Result)
123 35.5% 888 41.3% 888 41.3% 020 0 456 52.12% 030 0 If the number on column "C" its also somewere on column "A" I need the value on the righ of that number on column D. ie: if 888 is in column A I need the value of 888 wich is 41.3% on column "D" Result. Column "A" has thousands of rows that;s why I need a formula. I was thinking on this one. IF(COUNTIF(A2:A4,C2)0,B2) but doesn't give me the appropiate value it gave me in this case 35.5% of course. Please help, Thank you Hernan |