I have Two sheets in excel file, Sheet 1 and Sheet 2
Sheet 1 has different columns class, status, subject1 subject 2, subject N, along with no of pass fail and n.a students info.
Sheet 2 has columns named Class Subject Passed Failed N.A
I want to get pass fail and n.a from sheet 1 based on sheet 2 entered Class Subject Passed Failed N.A
For reference sheet is attached here. please help.
Last edited by kashifshahzad; 07-23-2016 at 08:50 AM.
Hi,
Give this a try:
It is an array formula that needs to be entered with CTRL, SHIFT & ENTER.
=INDEX(Sheet1!$C$2:$K$19,MATCH($A4&C$2,Sheet1!$A$2:$A$19&Sheet1!$B$2:$B$19,0),MATCH($B4,Sheet1!$C$1:$K$1,0))
Also need to change: Pass/Passed to match. One or the other. The same with Fail/Failed.
Also your subjects in Sheet1, "Urd" and "Math" have an extra space at the end of each that needs to be removed.
See attached example.
Hope this is helpful.
Cheers
Thank you very much, I really appreciate..
Glad I could be of some assistance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kashifshahzad 
Register To Reply
Bookmarks