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.
Bookmarks