Results 1 to 8 of 8

Using a list box to perform lookups on a table

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2010
    Location
    Birmingham England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Using a list box to perform lookups on a table

    In archery there are a number of different rounds shot (about 60).

    A particular score on a round results in a handicap rating.

    I have been trying to enter the score and the round shot (from a list box) and use a VLOOKUP to establish the handicap from a table.

    I can't figure out how to do it! How to make the table array a variable which can change according to the selection in the list box

    I have achieved the result I need in other ways on a small scale by having large nested IF statements based on the round name but there is a point when the formula gets too big.

    Can anyone help? Or can anyone come up with a macro to do it?

    I have attached a very simple example.

    Thanks
    Attached Files Attached Files
    Last edited by davidwp; 07-13-2010 at 09:37 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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