Results 1 to 2 of 2

Automatic data entry

This is a discussion on Automatic data entry within the Excel Questions forums, part of the Question Forums category; I'll try to make this simple and avoid having to use a diagram.... What I want to achieve is this; ...

  1. #1
    New Member
    Join Date
    Feb 2003
    Posts
    1

    Default Automatic data entry

    I'll try to make this simple and avoid having to use a diagram....

    What I want to achieve is this;

    I'm inputting infomation onto one page in a spreadsheet, 2 columns (Name and address)
    In another page on the same spreadsheet, I want to enter Name information and get Excel to update the corresponding address column automatically.
    I don't know if it is possible, but this is definitely the place to come for help.

  2. #2
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default Re: Automatic data entry

    Quote Originally Posted by japadamo@yahoo.co.uk
    I'll try to make this simple and avoid having to use a diagram....

    What I want to achieve is this;

    I'm inputting infomation onto one page in a spreadsheet, 2 columns (Name and address)
    In another page on the same spreadsheet, I want to enter Name information and get Excel to update the corresponding address column automatically.
    I don't know if it is possible, but this is definitely the place to come for help.
    You may want to try VLOOKUP

    =VLOOKUP(A1,RANGE,2,0),

    Where A1 would be where you enter the name
    Range is the data table of your information
    2 is the column from which your addresses reside
    0 is for FALSE, looking for an EXACT match or it reutrns #N/A

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com