If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP! I'm not sure what formula to use!
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 |
#2
|
|||
|
|||
HELP! I'm not sure what formula to use!
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 |
#3
|
|||
|
|||
HELP! I'm not sure what formula to use!
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 "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 |
#4
|
|||
|
|||
HELP! I'm not sure what formula to use!
Yes. Change the last parameter from False to True. Look up Vlookup in Help for
more information. -- Regards, Fred "HERNAN" wrote in message ... 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 "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 |
#5
|
|||
|
|||
HELP! I'm not sure what formula to use!
Use True only if you are looking for a range of data. If merely finding
matching data then False. -- Cheers "Fred Smith" wrote: Yes. Change the last parameter from False to True. Look up Vlookup in Help for more information. -- Regards, Fred "HERNAN" wrote in message ... 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 "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 |
#6
|
|||
|
|||
HELP! I'm not sure what formula to use!
Use TRUE is looking for range of data.
-- Cheers "Fred Smith" wrote: Yes. Change the last parameter from False to True. Look up Vlookup in Help for more information. -- Regards, Fred "HERNAN" wrote in message ... 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 "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 |
Thread Tools | |
Display Modes | |
|
|