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