- Messages
- 2,222
- Reaction score
- 6,346
- Points
- 523
🚀 NEW from the xtremepape.rs team: AI exam prep — 120,000+ worked solutions, and it marks your handwritten working from a photo. Sign in with your forum account & try it free → prepare.xtremepape.rs
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
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.
🚀 NEW from the xtremepape.rs team: AI exam prep — 120,000+ worked solutions, and it marks your handwritten working from a photo. Sign in with your forum account & try it free → prepare.xtremepape.rs