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