Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assemble link from different cells and return value | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel | |||
Can't link cells in worksheets in same workbook | New Users to Excel |