I have created a spreadsheet with client id numbers and addresses. On
another sheet, I need to be able to type in their id number and have excel
fill in other information such as gender and diagnosis in order to create a
bill. I do not need to include all clients. I need to find out how to fill
in the other columns. Is this a if-then formula? Would that include several
imbedded formulas? There must be an easier way!

Thank you!
Karen

You would use VLOOKUP to do this - generally of the form:

=VLOOKUP(id_num,your_data_table,column_num_to_retr ieve,0)

XL Help will give you more details, or you could post back with more
details of your own, eg sheet names, columns used for your data etc.

Hope this helps.

Pete

On Aug 12, 12:26*am, xololady
wrote:
I have created a spreadsheet with client id numbers and addresses. *On
another sheet, I need to be able to type in their id number and have excel
fill in other information such as gender and diagnosis in order to create a
bill. I do not need to include all clients. *I need to find out how to fill
in the other columns. *Is this a if-then formula? *Would that include several
imbedded formulas? *There must be an easier way!

Thank you!
Karen

Check out these 2 web pages of Debra Dalgleish:

http://www.contextures.com/xlOrderForm01.html

http://www.contextures.com/xlFunctions02.html
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

1
"xololady" wrote in message
...
I have created a spreadsheet with client id numbers and addresses. On
another sheet, I need to be able to type in their id number and have excel
fill in other information such as gender and diagnosis in order to create
a
bill. I do not need to include all clients. I need to find out how to
fill
in the other columns. Is this a if-then formula? Would that include
several
imbedded formulas? There must be an easier way!

Thank you!
Karen