+ Reply to Thread
Results 1 to 3 of 3

How to autopopulate a cell based on the result of 2 dropdown boxes

  1. #1
    Registered User
    Join Date
    02-05-2019
    Location
    PH
    MS-Off Ver
    2016
    Posts
    44

    How to autopopulate a cell based on the result of 2 dropdown boxes

    Hello. Any help is really appreciated

    I tried to use vlookup but it will only show the result of 1 dropdown list

    based on this video. youtube.com/ watch?v=QKcrJdFzOwE&t=354s[/url]

    I want to auto populate cell based on the result of 2 drop down boxes.

    on the sample file if they choose handhelds then gba green it should say "available" on the "result" column.

    but if they choose handhelds then gba yellow it should autopopulate to "sold" I was able to do this however

    How can you make it the same for pspgreen to autopopulate as availble then psp green as sold

    Thank you.................
    Attached Files Attached Files
    Last edited by g0dmenuelz; 02-11-2019 at 04:50 AM.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: How to autopopulate a cell based on the result of 2 dropdown boxes

    Like this in E7: =IF(AND($A$7="Handhelds",$C$7="gba yellow"),"sold",IF(AND($A$7="Handhelds",$C$7="gba green"),"available",""))
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    02-05-2019
    Location
    PH
    MS-Off Ver
    2016
    Posts
    44

    Re: How to autopopulate a cell based on the result of 2 dropdown boxes

    Thanks....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 03-28-2018, 04:26 AM
  2. Autopopulate cellls based on dropdown
    By El_Duderino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2014, 12:47 PM
  3. [SOLVED] Autopopulate certain cells based on the value of a particular cell
    By denisirio in forum Excel General
    Replies: 6
    Last Post: 04-18-2014, 04:27 PM
  4. Autopopulate multiple columns based on dropdown selection in far left column
    By tinaascoggins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2014, 12:29 PM
  5. Autopopulate using a dropdown menu
    By freybe06 in forum Excel General
    Replies: 6
    Last Post: 02-16-2011, 10:50 AM
  6. [SOLVED] autopopulate sl.no.based on a cell value
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 3
    Last Post: 10-21-2005, 03:05 AM
  7. Dropdown boxes (box 1 result = box 2
    By Greg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2005, 01:06 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