Hi,
I am haviang a problem with my workbook
My workbook contains several sheets
in the first sheet 'new clients' I have a column containing postcodeswhich
is added to daily
in the last sheet 'postcodes' I have a column containing a set list of
postcodes for certain areas of the country.
I want to check if the postcode entered in 'new clients' is listed in
'postcodes' and if it is put a 'yes' in the same row in 'new clients'.
I have tried lots of different formulas today but none are working.
help please