Results 1 to 6 of 6

Go to a cell in column, based on a reference number

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2010
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    7

    Go to a cell in column, based on a reference number

    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!
    Last edited by Joshua@work; 06-01-2010 at 07:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1