Results 1 to 3 of 3

Thread: Excel problum

  1. #1
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default Excel problum



    Dear Brothers,

    Mere pas excel ki do sheet hai inme kuch items hai me ye chahata hu ke sheet number 2 ka item no. 1 sheet no. 2 me hai to is ke aage yes likha aa jaye or agar nhi hai to no, kindly tell me something right............


    Thanking You


    Aklmand Wo Hai Jo Mout Se Pehle Mout Ki Tayyari Kar Le

  2. #2
    syar is offline Advance Member
    Last Online
    Today @ 04:20 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote Nadeem Ahmed Kh said: View Post


    Dear Brothers,

    Mere pas excel ki do sheet hai inme kuch items hai me ye chahata hu ke sheet number 2 ka item no. 1 sheet no. 2 me hai to is ke aage yes likha aa jaye or agar nhi hai to no, kindly tell me something right............


    Thanking You
    Try to Use match function with if for example
    Sheet2 A1 value with Sheet1 a1:10

    Code:
    =IF(MATCH(A1,Sheet1!$A$1:$A$10,0),"yes","no")
    change ranges/references accordingly.

    regards

  3. #3
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Quote syar said: View Post
    Try to Use match function with if for example
    Sheet2 A1 value with Sheet1 a1:10

    Code:
    =IF(MATCH(A1,Sheet1!$A$1:$A$10,0),"yes","no")
    change ranges/references accordingly.

    regards
    Shukriya Syar Bhai, formula kamyab rha thanking you............Great............

Similar Threads

  1. Microsoft excel shortcut keys
    By kainat khan in forum General Discussion
    Replies: 0
    Last Post: 21st January 2014, 09:09 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

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
  •