Help required to correct formula

Hi friends,

I want to retrieve marks from ‘result’ sheet to progress card.
There are 3 subjects on ‘Result’ sheet on different columns ‘o, q, r’
I want to retrieve the marks of these 3 subjects on progress card cell k8’
These are optional subjects so that the student has to take only 1 subject. So that for each standard the subject is different only 1 of these 3.

I’m getting error in the following formula:

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you.

Can you post the sheet? Remove any sensitive data.

Hi,
Please see the attached workbook.

Thank you.

In K8 Cell of Sheet2


=IFERROR(VLOOKUP(O5,Result!A:R,15,0)&"-"&VLOOKUP(O5,Result!A:R,17,0)&"-"&VLOOKUP(O5,Result!A:R,18,0),"Not Found")

Hi Sixthsense,
Thank you. It's working fine.

In the table I have used the index-match function for other subjects which are working fine but this is the only vlookup function in the table. I don't know how to use vlookup function.

The problem is solved but for my knowledge will you please use the vlookup function in the following index-match function formula? Please don't ask me to start a new thread for it. Simply send me a vlookup formula for it for my understanding and to learn new function.

Please Login or Register  to view this content.

Thank you for your kind help.

Have a nice day!

Try this...


=IFERROR(INDEX(Result!$O$7:$O$81,MATCH($O5,Result!$A$7:$A$81,0)),"")

Hi Sixthsense,
No! I want to know how to use vlookup function for the formula index-match I have posted. In short I want to how to use vlookup function for it. I want to learn vlookup formula which can be use instead of index-match.

Thank you.

May be this...?


=IFERROR(VLOOKUP($O5,Result!$A$7:$O$81,15,0),"")


Required result is Column-O so From A to O 15 columns. So use 15 in the above formula

Hi Sixthsense,
Thank you for your kind guidance to teach me a new function. Now I understood how to use vlookup function instead of index-match.

Now just for my curiosity and knowledge ...
1. What is the difference between these two function?
2. When to use vlookup and when to use index-match function?

Thank you and have a nice day.