+ Reply to Thread
Results 1 to 2 of 2

Free Form Text Box in a Search Field

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    16

    Free Form Text Box in a Search Field

    How can I allow users to either select the SKU from the dropdown menu, or to type in the SKU # in the dropdown menu (C5 through F5) and have it populate the data fields for that SKU when they press the 'Enter' key?

    Currently using Data Validation ='KVM Comparison Data'!$B$4:$OP$4 and cell logic to allow the information to be pulled from a hidden tab =INDEX('KVM Comparison Data'!$D$2:$OP$65,MATCH('KVM Product Comparison'!$B6,'KVM Comparison Data'!$A$2:$A$65,0),MATCH('KVM Product Comparison'!C$5,'KVM Comparison Data'!$D$4:$OP$4,0))

    In short, I want to keep it the way I have it, but allow users to also have the option of typing in a SKU and pull the data up that way. I know this is possible, I just can’t figure out how to do it, while keeping my current solution in place as well.

    Any help would be greatly appreciated!

    Rafi
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-16-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Free Form Text Box in a Search Field

    Bump....anyone have any feedback on how to do this? Thanks much in advance!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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