MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET

C

carrach

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
 
M

Mike H

Hi

=IF(COUNTIF(postcodes!$A$1:$A$20,B1)>0,"Yes","No")

This assumes the postode you have entered is in B1. Drag down as required
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to count cell text by value 13
How to create all possible pairs from a list of text data 2
Reducing the number of digits in a cell 6
using part of a cell to sort a list into groups 2
Adding a space inbetween letters and numbers in a cell 2
How do I cut and paste using a macro.... 1
Excel Reference to text returning "0" value on second column 0
select part of a cell value string 2

Top