Results 1 to 12 of 12

Thread: plz help me urgent

  1. #1
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Thanked
    30

    Default plz help me urgent

    dear friends maine excel main ek file banai hai jis main 2 sheets hain
    ek Dec-09 or dosri Outstanding k name se.

    main yeh chahta hon k Dec09 wali sheet ka challan no or outstaning wali sheet ka SR.No match ho ker mujhe Match SR.No k Cell main show hon.
    file attach ker raha hon agar koi help ker saky tu mehirbani hogi

    thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    22 Oct 2009
    Location
    ~*Dream*World*~
    Gender
    Male
    Posts
    21,935
    Threads
    299
    Credits
    1,349
    Thanked
    1701

    Default

    Sorry friend, hum sakjh nahin paaye.
    ~* W@R T!ll D3@t|-| *~
    ~* I'll Win Not Immediately But Definitely *~

  3. #3
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    Aap ki dec-09 ki sheet m teen table hain aap kis table k Sr.No outstanding k sheet se match karna chahte hain

  4. #4
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Credits
    0
    Thanked
    30

    Default

    Quote syar said: View Post


    Aap ki dec-09 ki sheet m teen table hain aap kis table k Sr.No outstanding k sheet se match karna chahte hain
    dear main "Dec09" k "Challan No" waly cell se match kerna chahta hon.

    "Dec-09" ka "Challan No" wala cell match ho "Outstanding" wali sheet k "SR.No" walay cell se or us ka result "Match SR.No" Cell main aey jo k "Outstanding" wail sheet main maine bana diya hai.

  5. #5
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    bhai leekan aap ki dec-=09 ki sheet m teen mukhtalif ranges hain. 1st a6:a10, 2nd a30:a32 3rd a53:a72 jin m aap ne number bhee repeat kiye howe hain. aap ko konsi range ko match karna ha. agar sab ko Tu aap ko wrong answer bhe mil sakta hain. kiyon k match ko jahan bhee pehla match mela ga wo wohe value return return kare ga.

  6. #6
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Credits
    0
    Thanked
    30

    Default

    dear maine ab sheet main hight light ker diye hain cells jo k match kerny hain ap meri is attachment main samjh jaenge k mujhe kiya match kerna hai.

    thanks
    Attached Files Attached Files

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Well, Take a look or this is your solution.
    Attached Files Attached Files

  8. #8
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Credits
    0
    Thanked
    30

    Default

    Quote syar said: View Post
    Well, Take a look or this is your solution.
    thank u very much dear syar.
    main vlookup use ker raha tha per mujhse galati ho rahi thi jis ki wajha se mujhe answer nahin mill raha tha.

    thank u again.

  9. #9
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Sorry m pehle dafa m aap k challan k column ko miss kar gaya tha.

    agar aap vlookup se return hone wale #NA ko ignore karna chahte ho tu ye modified formula apply karain . #NA ki gajha cell blank rahe ga.

    =IF(ISNA(VLOOKUP(A3,'Dec-09'!$F$6:$F$71,1,FALSE)),"",VLOOKUP(A3,'Dec-09'!$F$6:$F$71,1,FALSE)).

    Thanks & regards

  10. #10
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Credits
    0
    Thanked
    30

    Default

    Quote syar said: View Post
    Sorry m pehle dafa m aap k challan k column ko miss kar gaya tha.

    agar aap vlookup se return hone wale #NA ko ignore karna chahte ho tu ye modified formula apply karain . #NA ki gajha cell blank rahe ga.

    =IF(ISNA(VLOOKUP(A3,'Dec-09'!$F$6:$F$71,1,FALSE)),"",VLOOKUP(A3,'Dec-09'!$F$6:$F$71,1,FALSE)).

    Thanks & regards
    thank u.
    or dair ek chez is main or add kerna chahta hon woh yeh k jahan same R.No show ker raha hai agar wahan ek or cell main bana don taky uska name bhi same show kary tu is formuly ko kaise use karon?
    agar ker sakty hain tu thek hai werna ap ny itni meri help ki us k liye main ap ka tah-e-dil se thanks kerta hon.

  11. #11
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    New column m try this and reply me. Naya column match sr.no k baad banaye

    =INDEX('Dec-09'!$B$6:$B$71,MATCH('Outstanding Dec-09 PN to X'!A3,'Dec-09'!$F$6:$F$71,0))

  12. #12
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Credits
    0
    Thanked
    30

    Default

    Quote syar said: View Post
    New column m try this and reply me. Naya column match sr.no k baad banaye

    =INDEX('Dec-09'!$B$6:$B$71,MATCH('Outstanding Dec-09 PN to X'!A3,'Dec-09'!$F$6:$F$71,0))
    syar bhai buhat buhat mehirbani ap ny mere sary kam ker diye.
    excelllent

    thank u very very much again and againg..
    Gold Bless You. Aamen

Similar Threads

  1. vvvvvv urgent mem card please come on vvvv urgent
    By lovtam in forum Ask an Expert
    Replies: 11
    Last Post: 5th December 2017, 12:56 PM
  2. koi sasta sa ur acha sa mobile for voice chat urgent urgent urgent help
    By kashifundlas in forum Mobile phones problems and Help Zone
    Replies: 8
    Last Post: 22nd July 2012, 04:56 AM
  3. Solved urgent help in ms word please very urgent ..experts plese come on
    By lovtam in forum Solved Problems (IT)
    Replies: 4
    Last Post: 13th December 2010, 07:47 PM
  4. adobe ps urgent help plz urgent urgent dont refuse
    By lovtam in forum Ask an Expert
    Replies: 3
    Last Post: 3rd July 2009, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •