Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trev[_2_] Trev[_2_] is offline
external usenet poster
 
Posts: 32
Default lookup

I have a workbook and on sheet 1 I have entered information in columns A thru
R. I am needing a formula that will populate sheet 2 when I enter an
identifying number. Example
Sheet 1
ID#, Address, Date, Phone, etc.
So when I enter the ID# on Sheet 2 all the info in column B thru R is
populated in sheet 2.
Thanks,