Results 1 to 3 of 3

Cross Reference (Vlookup) based on Data Validation List Dropdown

Threaded View

eguirocker3 Cross Reference (Vlookup)... 06-19-2014, 04:23 PM
ChemistB Re: Cross Reference (Vlookup)... 06-19-2014, 04:31 PM
eguirocker3 Re: Cross Reference (Vlookup)... 06-19-2014, 05:02 PM
  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    75

    Cross Reference (Vlookup) based on Data Validation List Dropdown

    Attached is example of what I'm trying to do. I want to use the drop-down on the "Master Tab" and have the corresponding price by promo_month appear in the yellow cells. Does anybody know of a formula or how to do this?

    Currently its on July, but I would like to switch that to August etc and have new prices populate in the yellow cells. Prices come from the "table" tab.

    Let me know with any questions, thanks.
    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. Auto-Generate List from reference cells based on data validation list selection
    By BoundCustomDesign in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2014, 11:06 AM
  2. [SOLVED] Data Validation List to Return Variable/Dynamic Data based on Reference Table
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 09:08 AM
  3. Dropdown list // VLOOKUP using an external file as reference question
    By jlg_silva in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-18-2014, 11:44 PM
  4. Match and VLookup to cross reference data
    By MrO in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-05-2013, 03:53 PM
  5. data validation cross reference
    By sdts in forum Excel General
    Replies: 4
    Last Post: 07-28-2011, 11:30 AM

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