Lookup
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 |
Lookup
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 |
Lookup
Sounds like a simple vlookup function to me. =vlookup(A1,"Page2 A1:A2",2,0) -- PowerWheels ------------------------------------------------------------------------ PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045 View this thread: http://www.excelforum.com/showthread...hreadid=497398 |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com