Hi,

Try this:

=VLOOKUP(C1,A1:B100,2,FALSE)

Assumed you data is in A1:C100

Thanks,
--
Farhad Hodjat


"HERNAN" wrote:

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