Substituting values

[Guest]

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?

 

[RagDyer]

Sounds like Vlookup should work for you.

Check out this site of Debra Dalgleish on this function:

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