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!! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
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!! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
<!-- controls -->
