creating a spreadsheet

  • Thread starter Thread starter Naomi
  • Start date Start date
N

Naomi

I need to know where I may find information on creating a
spreadsheet for my business. What I need it to do is
automatically enter information to selected cells by
typing in a 9 digit number. This would be nice if it could
be used in conjunction with an address book. I know that
Quattro Pro could be set up this way but I have no idea
how to start or if Excel can do it. My main problem is I
know what I need it to do but do not have the knowledge of
the correct language and terms that are used in the books
or articles I have read. I work with Excel every day but
very very generic spreadsheets. If anyone could help me
find this information I would appreciate it.
Thanks
Naomi
 
In excel, unless you are going to write code/do programming, you would need
to create a table with your 9 digit numbers on the leftmost column and the
remainder of the data in columns to the right. This would essentially
represent you address book.

Then in your worksheet where you want to enter the 9 digit number and return
data, you would put in formulas similar to (assume 9 digit number is enter
in C9):

=if(C9="","",Vlookup(C9,Table1,2,False)

Where Table1 is the range reference to your Address book data such as
DataSheet!A1:Z500

This formula would look down column 1 of the sheet named Datasheet, find the
9 digit number and return the corresponding value in that row found in
column B (the 2 as the third argument of the vlookup function, a 3 would get
the data from column 3 as an example).

So look in Excel help for Vlookup.
 
Back
Top