- Messages
- 2,222
- Reaction score
- 6,346
- Points
- 523
ohhhh , jazakALlah
waiyyaki
We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
Click here to Donate Now (View Announcement)
ohhhh , jazakALlah
waiyyaki
i am sure ur laughing rit now , what can i do , comp source files wrongly arranged hai toh
nah i wasn't laughing but now i'm laughing at ur comment...!!
anyways in d begenning of d question ppr they specify d files required...u should check it...
yeah rit , i eally get bored to read that stuff, exam mein chalo i mit read it , par at home , never!!
jazakallahu khairhere are the screenshots
make sure that you've made the correct relationship as its in the screenshot
View attachment 32351
if you still cant do it then you can manually get the result by entering the criteria in your query instead of creating a duplicate one like this:
View attachment 32352
jazakallahu khair
any way other dan d manual 1? cz i tried normally n nth came
d report still can't b made..
sorry 4 asking so much..
i am sure ur laughing rit now , what can i do , comp source files wrongly arranged hai toh
in d qp they've told which files ur supposed 2 have
so u import only those
paper year?
S10 question 3
in CELL A4
=IF(A2<>"",VLOOKUP(A2,lookup table array,3,FALSE),"")
in CELL C2
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,11,FALSE),"")
here u have to change d number after d table array...for eg: it is 11 here coz IDACOPT5 is in d 11th column
so for the next cell u will put 6 n NOT 11 coz it's IDBC04 so it will b (in cell C3)
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,6,FALSE),"")
in CELL D2
=IF(C2="y",VLOOKUP(B2,lookup table array,3,FALSE),"")
AAnsarii plz check if it is right coz i did it n got d correct answer...
in column C, d heading specifies Y/N. so u just add an if:
=IF($A$2<>"",IF(VLOOKUP($A$2,lookup table array,11)<>"","Y","N"),"")
ie, if its nt empty, (so it'll hv "y" in it) u put Y, n if it is empty, put N.
For almost 10 years, the site XtremePapers has been trying very hard to serve its users.
However, we are now struggling to cover its operational costs due to unforeseen circumstances. If we helped you in any way, kindly contribute and be the part of this effort. No act of kindness, no matter how small, is ever wasted.
Click here to Donate Now