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

I am trying to find a function for a list
 

Try this...

=IF(ISNUMBER(MATCH(A8,'Prior Month'!Q:Q,0)),"Checked","")

--
Rick (MVP - Excel)


"soconfused" wrote in message ...
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

I am trying to find a function for a list
 

try this

=IF(ISNA(MATCH(Q5,sheet2!$A$1:$A$100,0)),"","check ed")


On Dec 4, 12:22*am, soconfused
wrote:
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

I am trying to find a function for a list
 

This should work:
=IF(COUNTIF('Prior Month'!$A$1:$A$100,Q5)0,"Checked","")

(but it's not a case sensitive check)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"soconfused" wrote:
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 an 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

I am trying to find a function for a list
 

Hi soconfused, you were soclose

=IF(COUNTIF('Prior Month'!$A$1:$A$100,Q5)0,"Checked","")

Mike

"soconfused" wrote:

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

I am trying to find a function for a list
 

Thank you all for contributions. Muddan, yours was the one that was
successful.

--
DMM


"muddan madhu" wrote:

try this

=IF(ISNA(MATCH(Q5,sheet2!$A$1:$A$100,0)),"","check ed")


On Dec 4, 12:22 am, soconfused
wrote:
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

I am trying to find a function for a list
 

Actually, all 3 other options should have worked just as well. Rick's
ISNUMBER(MATCH(..)) option is identical (conversely) to Muddan's
ISNA(MATCH(..)), it just needs some tweaking on the lookup/col references.
The COUNTIF option was tested ok here before posting it to you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"soconfused" wrote in message
...
Thank you all for contributions. Muddan, yours was the one that was
successful.

--
DMM