Use vlookup. In B2: =vlookup(a1,'Page 1'!$a$1:$b$100,2,false)

"Brent" wrote:

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