| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to find a function for a list
I have one worksheet with two sheets. On the first sheet I have a list in
column Q. I want to check that row against column A in the second sheet. If I find and exact match, I want to put "Checked" in column AA, if not I want it to be blank. This is the formula that I've tried: IF(COUNTIF('Prior Month'!$A$1:$A$100,Q5)"","Checked","") -- DMM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find in list function | New Users to Excel | |||
| Can VLookup function find and list multiple records? | Excel Worksheet Functions | |||
| how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
| i need a function to find the highest value in a list | Excel Worksheet Functions | |||
| how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
Threaded Mode
