Array function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=IF(ISNA(MATCH("A1",Sheet2!A1:A1000&Sheet2!C1:C1000,FALSE)),"","X")
 
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?
Click to expand...

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
 
Back
Top