Results 1 to 2 of 2

Excel Combo Box and VLookUP

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2008
    Location
    London
    Posts
    1

    Excel Combo Box and VLookUP

    What I want is if user selcts say Data from combo box in a cellC19 and then enters a number value like 400 into K19 then Cell O19will equal K19*0.2 to give value in O19 else user may enter value in L19 and if so then I want L19*0.5 to then equal O19 say just for example
    But I want this for all cases in the combo Box i.e I have 10 cases
    How will I do this for all cases..
    Also if user enters value in either K19 or L19 is there a way so he can not enter in both just one entry
    See attached file
    Attached Files Attached Files

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