Results 1 to 2 of 2

Thread: About Excel (Vlookup and DropDown)

  1. #1
    shan4shan is offline Senior Member+
    Last Online
    5th October 2015 @ 03:49 PM
    Join Date
    24 Feb 2009
    Location
    Buraydah, Alqassim
    Age
    37
    Gender
    Male
    Posts
    108
    Threads
    37
    Credits
    955
    Thanked
    5

    Default About Excel (Vlookup and DropDown)

    Assalam O Alaikum!

    MS Excel Experts please help me out
    ye jo image he is me jo ITEMS hen in ko meine drop downlist mein chahiye r phir in k aagey jo costs hen, tw in ko vlookup k zarye inhin item se connect krane hen ta k jese hi dropdown me mein select krun tw cost khud hi ajae..

    please hurryup

    thankss alot
    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 shan4shan said: View Post
    Assalam O Alaikum!

    MS Excel Experts please help me out
    ye jo image he is me jo ITEMS hen in ko meine drop downlist mein chahiye r phir in k aagey jo costs hen, tw in ko vlookup k zarye inhin item se connect krane hen ta k jese hi dropdown me mein select krun tw cost khud hi ajae..

    please hurryup

    thankss alot
    Walikum Salam,

    Assume k sheet 1 k A1 m aap drop down list banana chahte hain.
    1. Formula k tab m Jain
    2. Define Name p Click Karain
    3. apne list ko ( as per your attached screen shot Column A k item ko select karain aur use koi bhe name d dain e.g. Item
    4. ok Kar dain.

    5. Phir jahan aap ko drop down list chaheye us cell m click krain
    6. Data k tab m jain
    7. Data Validation p click karain
    8. Allow k box m sa LIST ko Select Karain
    9. source k box m ya formula lekhain
    Code:
    =Item
    10. ok kar dain. aap ki drop down tayar ha
    11. phr adjacent cell m vlookup ka formula laga lain. ab jab bhe aap drop down m sa value select karain ge. price change hote jae gi.

    range and references changes accordingly.

    regards

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
  •