I don't know why I received a violation, I changed the title to now match what I am trying to accomplish from the original question. I tried the formulas you suggested, this is what I would hope to accomplish

in column B70 there is a number that is pulled into this field. Once the number is entered into that field, in Column C, can a formula be written to say:

If a number is found in Column b70, then pull in the name list adjacent to that number. So if the number is pulled in from B10, pull in the name from C10? This formula would have to written with a wildcat element to?? so it can recognize number pulled into B70, and find the corresponding name in column C.

The formulas you suggested find a random name but the name that is found does not associate to the random number selected???

I hope I don't receive another violation notice-I am not trying to be misleading
Thanks for your help