Array function?

[Guest]

Hi

Wondering if anyone can help me with my worksheet...

I need it so that cell A1 on Worksheet 1 displays an 'X' if and when "A" is entered in any row on column A and "1" is entered in column C in the same row on Worksheet 2.

Does this make sense?

 

[Frank Kabel]

Hi
try in A1
=IF(SUMPRODUCT(--(A2:A100="A"),--('sheet2'!C2:C100=1)),"X","")

 

[JE McGimpsey]

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=IF(ISNA(MATCH("A1",Sheet2!A1:A1000&Sheet2!C1:C1000,FALSE)),"","X")

 

[Ron Rosenfeld]

Hi

Wondering if anyone can help me with my worksheet...

I need it so that cell A1 on Worksheet 1 displays an 'X' if and when "A" is entered in any row on column A and "1" is entered in column C in the same row on Worksheet 2.

Does this make sense?

And here's another way -- NOT an array formula:

=IF(COUNTIF(Sheet2!A:A,"A"),IF(VLOOKUP("A",Sheet2!A:C,3,0)=1,"X",""),"")




--ron