| 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 |
| 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 | |||
Threaded Mode
