Returning True If Data Is in Range

Suppose you have a list A1-A13:
1
2
3
4
5
3
4
5
6

and you want to see if the Cell C5 is in this list. E.g c5 = 5

=COUNTIF(A1:A135,C1)>0

Would work.

Now what happens if your range is on a different workbook.

r_t.xlsx (A1)

being your workbook name

sheet1 (B1)

(as it is in sheet one)

$A$1:$A$10 (C1)
Being your range.

="["&A1&"]"&B1&"!"&C1 (d1)
being your formula

=INDIRECT(D1) (e1)

being your functon to retrive the data.

Calling my previous =COUNTIF(E1,A3)>0 Using e1, would not compare the whole list; as only one reslt is bein returned by E1.

PLEASE HELP!!

What about:

=COUNTIF(INDIRECT(D1),A3)>0

On my test it worked perfectly.

Please note that the source book has to be open.

It is correct as far as syntax... but your original formula showed A1:A135 as a range.. do you need that coverage or not?