Substituting values
 

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?

Substituting values
 

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?