Results 1 to 10 of 10

VLOOKUP match of column gives a result with a max of x

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    West Virginia, US
    MS-Off Ver
    Excel Pro Plus 2019
    Posts
    69

    VLOOKUP match of column gives a result with a max of x

    So what I am trying to do is use a pull down on one worksheet linked to a table on another worksheet allow the user to only input a number from 1 (always the minimum) to x (which is the number found in the table).
    Currently it is showing #VALUE which is probably related to the pull down bringing up a term versus a number. I am unsure how to correct it.

    =IF(B23="",1,MAX(VLOOKUP(B23,Talents!C4:Q134,4,FALSE)))


    C23 is the cell i would like the user be able to select a number. The pull down is in B23 and it will bring up a term. that term is linked to a table on the Talents tab (in the C column) the maximum that x can be is found in column 4 in the table (the minimum is always 1 and the max can b anything from 1-10).

    I am fairly new to excel so I am sure I am screwing something up. Thank you for any help.
    Attached Files Attached Files
    Last edited by MrO; 12-03-2012 at 12:41 PM.

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