| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match cells
I would like to find out if cells in a column on one worksheet match any
cells in a range on another worksheet. I have a list of plan codes that locate in a report. any help would be greatly appreciated. thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match cells
In Sheet1 colA you have the plan codes list1
In B1 enter the below formula....(copy the formula down as required) =IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"No match","Match") which will look at Sheet2 Column A to find a match.. If this post helps click Yes --------------- Jacob Skaria "Jason K" wrote: I would like to find out if cells in a column on one worksheet match any cells in a range on another worksheet. I have a list of plan codes that locate in a report. any help would be greatly appreciated. thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Match Dates in Two Cells and Ignore subsequent Cells | Excel Discussion (Misc queries) | |||
| how to show whether 3 cells within a row match 3 cells in another | Excel Worksheet Functions | |||
| Match cells with cells on another workbook | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
![Jason K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
