HELP! I'm not sure what formula to use!

[Guest]

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

 

[Guest]

Hi,

Try this:

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

Assumed you data is in A1:C100

Thanks,

 

[Guest]

Thank you so much it works really well. What if I don't have that match is it
possible to set it up to go for the closer number, ie if I'm looking for 1000
and doesn't find that number to start looking for 1001 or 999 until it find
it? or maybe another formula next to that one, if error then < or > 100
something to set a range of numbers?
Thank you so much anyway I really appreciate.
Hernan

 

[Fred Smith]

Yes. Change the last parameter from False to True. Look up Vlookup in Help for
more information.

 

[Guest]

Use True only if you are looking for a range of data. If merely finding
matching data then False.

 

[Guest]

Use TRUE is looking for range of data.