fill in client list for bill

[xololady]

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

 

[Pete_UK]

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

=VLOOKUP(id_num,your_data_table,column_num_to_retrieve,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

 

[RagDyer]

Check out these 2 web pages of Debra Dalgleish:

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

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