Results 1 to 2 of 2

Thread: kia es main vlookup lag sakta hay

  1. #1
    sabir sami is offline Senior Member+
    Last Online
    11th December 2016 @ 08:10 PM
    Join Date
    22 Dec 2010
    Location
    MULTAN
    Age
    38
    Gender
    Male
    Posts
    143
    Threads
    65
    Credits
    11
    Thanked
    2

    Default kia es main vlookup lag sakta hay

    sir main es formula mian vlookup lagana chata hon kis jaga set ho ga es formula main jhan jhan vlookup lag sakta hay tu plz example day ker wazahat ker dain main ap ka buth shuker guzar hon ga

    =IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$ C$5>SUM(sheet1!A$5:$E5),sheet1!$E5,sheet1!$E$5-SUM(sheet1!A$5:$E5)))

    plz help zoree kejay ga

    thnx

  2. #2
    sabir sami is offline Senior Member+
    Last Online
    11th December 2016 @ 08:10 PM
    Join Date
    22 Dec 2010
    Location
    MULTAN
    Age
    38
    Gender
    Male
    Posts
    143
    Threads
    65
    Credits
    11
    Thanked
    2

    Default kia es main vlookup set ho sakta chick again file attach

    sir main file attache ker raha hon

    es main item code ko vlooup lagana hay

    =IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$ C$5>SUM(sheet1!A$5:$E5),sheet1!$E5,sheet1!$E$5-SUM(sheet1!A$5:$E5)))



    =IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$ C$5>SUM(sheet1!A$5:$E6),sheet1!$E6,Sheet2!$C$5-SUM(sheet1!A$5:$E5)))

    thx
    Attached Files Attached Files

Similar Threads

  1. Replies: 10
    Last Post: 28th September 2011, 04:29 PM
  2. excel main vlookup or hlookup kaise use kartai hain
    By toolplaza in forum Ask an Expert
    Replies: 1
    Last Post: 12th June 2011, 02:19 PM
  3. Replies: 5
    Last Post: 14th November 2009, 05:24 PM
  4. kia mujhe koi bata sakta hai ke main kahan se live tv dekh sakta hoon?
    By master_mind630 in forum Solved Problems (IT)
    Replies: 10
    Last Post: 14th November 2009, 05:22 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
  •