I would like to type a value on one page of my worksheet. Then have a
function in the column next to the value that looks up the value typed in and
references it to a table on anohter page and returns the value (text) that is
associated with that number. -example-

Page 1 Page 2
1 Jim so if I input 1
in A1; B2 returns Jim
2 Stan
3 Kim
4 Alan