We have a liability for works carried out by certain companies. These are all identified by a six figure number.
We have a list of numbers we are liable for.
We also have a list of their contact numbers, names and addresses.
I need to be able to manually enter the 6 figure number into a cell, this will then recognise the number (or not) and flag up "liability" or "no liability" (or similar) in a separate cell. A third cell then needs to display company details contact numbers etc if indeed we are liable.
Anyone fancy the challenge of explaining to little numpty me how to do this
Thanks in advance