Sounds like Vlookup should work for you.

Check out this site of Debra Dalgleish on this function:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"TLC" wrote in message
...
I am not exactly sure where this should go. Here is my situation in a
nutshell: I am randomly generating 100 numbers from 1-64. (I can do that
in
2007!) I want the value to compare to a table where I have 1-64 in one
column
and data in the adjacent column. Can I get the random number input to
check
the table and spit out the data value versus the number value?