Sounds nice. Where is the data coming from? Take a look at these links for
some ideas of how you can go about doing this:
http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlFunctio...tml#IndexMatch

http://www.contextures.com/xlFunctio...ml#IndexMatch4

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Bonnie" wrote:

I am building an inpatient log for a nursing home. I need to auto fill the
patient's name and address from their ID #

Example in column C (ID#) 255 - would automatically fill in Column D (last
name), Column E(first name), Column F(middle initial), and Column G(address)

At this point - all of the cells are blank.