| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET
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. "carrach" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET
=IF(ISNUMBER(MATCH(A1,postcodes!A:A,0)),"yes","no" )
-- David Biddulph carrach wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET
But Mike's COUNTIF solution makes more sense. I must have been asleep. :-(
-- David Biddulph David Biddulph wrote: =IF(ISNUMBER(MATCH(A1,postcodes!A:A,0)),"yes","no" ) carrach wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching column in different sheet | Excel Discussion (Misc queries) | |||
| Matching and returning values to a master sheet in Excel 2007 | Excel Worksheet Functions | |||
| Macro to find matching date and copy values to another sheet | Excel Discussion (Misc queries) | |||
| Select 50 greatest values with column matching | Excel Discussion (Misc queries) | |||
| find a cell matching separate column and row values | Excel Worksheet Functions | |||
Linear Mode
