Results 1 to 3 of 3

Input cell value based on multiple dropdown list to populate

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-14-2016
    Location
    UAE
    MS-Off Ver
    MS OFFICE 2016 & 2019
    Posts
    154

    Input cell value based on multiple dropdown list to populate

    Hi,

    i have created table for lookup data from "B4:E15" and i created a data validation list on other columns. Now what i need if i enter the value of Employee id in column "J " which indicates in yellow color the other dropdown list column in " H, I, K" to display the correct information to populate based on the Lookup table.


    pls see the attachment file for example...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populate in-cell dropdown list with values based on sheet name
    By mks16 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-21-2015, 09:35 AM
  2. Populate table based on time selected in dropdown list
    By jmp764 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2014, 10:51 AM
  3. [SOLVED] Display a dropdown list or populate a cell with single value based on other cells' values
    By filla_dilla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 09:47 AM
  4. Replies: 3
    Last Post: 11-07-2013, 11:40 AM
  5. Replies: 6
    Last Post: 05-31-2013, 11:17 AM
  6. Save Multiple Files based on List AND Populate a Cell with value
    By aetedford in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 04:25 PM
  7. Populate a cell based on input from a drop down list
    By TroyDurham in forum Excel General
    Replies: 9
    Last Post: 01-19-2009, 09:47 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1