Hi

I need to be able to enter a text abbreviation to represent a client address
in a cell for it to return the full address in the same cell

ie

If I type MD in cell A1 it will return MacDonalds, Unit 5............etc in
the same cell

I have a database sheet which is referenced for the full address and use the
IF formula to locate the correct address from the abbreviated text.