Hello everyone, im new here hope you can help me with this problem.
My problem is how to get a value from a table or data using functions. I really can't explain it but please take a look at my sample file and give me a solution. ive tried lookup but the results are a mess.
problem_zps73ea5f09.jpg
http://www.mediafire.com/download/l1...t/problem.xlsx
thank you very much. im not really into functions and ill really appreciate it downloading my file and solve it. thanks you.
Last edited by crisarrows; 06-23-2013 at 01:36 PM. Reason: Thanks to Wayne
use vlookup or index match
for vlookup
=VLOOKUP(A6,$I$6:$J$16,2,FALSE)
and copy down
it will give a #N/A if no name found in the table- so what do you want to happen then
and just for completeness index match would be
=INDEX($J$6:$J$16,(MATCH(A6,$I$6:$I$16,0)))
sometimes more efficient to use
so i put that in column C as an example
see attached
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you so much, really appreciated it. But how can i removed the N/A i downloaded the attached and check on the column B and C using but is has the N/A. i need to sum it at the bottom.
Thank you Wayne.
do you want zero or blank
depends on how you are summing
Sum(B6:B13) will be OK with ""
But B6+B7+B8 etc will not
=IFERROR ( VLOOKUP(A6,$I$6:$J$16,2,FALSE) , "")
is a blank
OR
=IFERROR ( VLOOKUP(A6,$I$6:$J$16,2,FALSE) , 0)
is a zero
same for index/match
=IFERROR ( INDEX($J$6:$J$16,(MATCH(A6,$I$6:$I$16,0))) , 0)
Last edited by etaf; 06-23-2013 at 12:47 PM.
Originally Posted by etaf
Sir, thank you so much for your help. you save me a lot of time with this problem. again sir. Thank you.
you welcome
if you care to - we have a reputation button the * here , to add to members reputation
Done. Sir. Thank you again.
thank you - glad it worked OK for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks