| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function to match colunms
Hi,
I have a column of numbers in A which I would like to match if they appear in col G, I am using the following if function this works for only 1 cell and when I drag this down it returns no match when I know there is a match available. IF(A2:A15=G:G,"Match","no Match") Any help would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change in colunms of sheet- and macro ? | Excel Discussion (Misc queries) | |||
| Compare two file/colunms, hide row not does not equal list. | New Users to Excel | |||
| Matching data in multiple colunms | Excel Discussion (Misc queries) | |||
| Comparison of data in two separate colunms | Excel Discussion (Misc queries) | |||
| creating spreadsheet with colunms for names adresses & zipcodes | Excel Discussion (Misc queries) | |||
Threaded Mode
