Results 1 to 3 of 3

Thread: Dropdownlist and Vlookup

  1. #1

    Dropdownlist and Vlookup



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    In the attached spreadsheet, i created a dropdownlist consisting of 3 associates` items (Nermine, Heba and Mohamed) and used the Vlookup function to lookup for the data of each item. Now i`ve got two problems:

    1- How can i add and enter ( payed) column for each item ?

    2- How can i calculate the sum of payed price for each associate ?
    Regards
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,490
    Articles
    0
    Excel Version
    Excel 2016
    Your question is unclear. Can you repost your workbook showing expected results and why?


  3. #3
    Cross posting in Excel Forum

    excelforum.com/excel-formulas-and-functions/902276-dropdownlist-and-vlookup.html
    Regards

    Fotis.
    . Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.

    . -Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.

    .--Don't attach a screenshot--Just attach your Excel file!

    .--KISS(Keep it simple Stupid)

Posting Permissions

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