View Single Post
  #1   Report Post  
IndianRelic
 
Posts: n/a
Default using item#s to link cells


Hi guys,

I am trying to create a worksheet that requires an specific item# to be
entered into a cell, which has values attached/linked to this.

for example:

if a user enters a drivers license number in one cell (blank, no
dropdowns), then the Name, birthdate, and any other data that is linked
to that number appears in designated cells.

All the drivers license numbers are stored on on sheet 2 with their
Names and birthdates. I need to pull this info into sheet 1 by entering
a drivers license number...

I hope this makes sense...

Thanks :)


--
IndianRelic
------------------------------------------------------------------------
IndianRelic's Profile: http://www.excelforum.com/member.php...o&userid=26480
View this thread: http://www.excelforum.com/showthread...hreadid=397461