See help on VLOOKUP for populating cells based upon an entry in one cell.


Gord Dibben MS Excel MVP

On Sat, 13 Mar 2010 08:41:59 -0800 (PST), Johnnyboy5
wrote:

I would like to auto complete a row rather than just whats in a cell.

The key words are in column A (medication) and in column B what its
for etc

so when you start typing a medication in if is already there then it
will auto complete the cell and also bring the other data from the
same row.


many thanks


Johnnyboy