View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TLC TLC is offline
external usenet poster
 
Posts: 23
Default 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?