Hello All,
What I have is a list of unique file numbers in colmun A and information pertaining to each file in that column,(file name, dates, etc). What I would like to do, is to create a formula where I could enter a reference number into a blank cell, a number that matches one of the numbers in cloumn A, and be taken not only to that column, but a predetermined row next to that column so that I may enter more information.
EXAMPLE: I want to be able to enter say the first number "0732556005" into a cell and automatically be taken to C3 so that I can fill in the blanks.
.......A............................B.....................C
0732556005..............MARTINEZ
0806798004..............HILL
0733453653..............NIETO
0727552104..............PHILLIPPI
0724752147..............STATEN
0827555212..............LAMBSON
0733331605..............JUANGCO
095395JAP..............WARD
0801131590..............TREJO
0705153068..............FOX
096637MLR..............BANSEMER
0618631063..............PETERSON
0617798002..............GANDY
098297MZ..............DACOSTA
0707344543..............HINSEY
097681BKS..............HUCKABY
0733756111..............WELLS
0636034503..............ALVERIO
0728331038..............HOWARD
Please let me know if this is enough information. Thanks guys!
Bookmarks