Results 1 to 2 of 2

Thread: Excel Vlookup Formula.

  1. #1
    chandr is offline Senior Member+
    Last Online
    8th March 2020 @ 02:19 AM
    Join Date
    26 Oct 2008
    Posts
    68
    Threads
    29
    Credits
    1,244
    Thanked
    0

    Default Excel Vlookup Formula.

    any one help me in vlookup formula. currently i am entering formula =Vlookup(B6,F6:G10,2,False). but it displays amount of only one code. my requirement is the sum of all codes. please help me. picture is attached for your reference.
    Attached Images Attached Images  

  2. #2
    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

    Quote chandr said: View Post
    any one help me in vlookup formula. currently i am entering formula =Vlookup(B6,F6:G10,2,False). but it displays amount of only one code. my requirement is the sum of all codes. please help me. picture is attached for your reference.

    aap vlookup ki jagha sumif ka formula use karain. see excel hep for sumif or search shehzada iqbal tutorial on sumif in "URDU tUTORIAL" section.

    =SUMIF(F6:F10,B6,G6:G10)

    regards,

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. Need help in excel / vlook formula ka istamal
    By imrangadit in forum Ask an Expert
    Replies: 0
    Last Post: 8th January 2013, 07:08 AM
  3. Solved Excel Formula
    By Qutab in forum Solved Problems (IT)
    Replies: 10
    Last Post: 26th January 2012, 08:48 PM
  4. What is Excel Formula for Difference in Two Values ?
    By Baazigar in forum Ask an Expert
    Replies: 2
    Last Post: 30th May 2011, 09:45 PM
  5. Excel main Less Than ka Formula?
    By flower_toyou8 in forum Solved Problems (IT)
    Replies: 19
    Last Post: 22nd July 2010, 04:27 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
  •