Looking for a Function

[tkollaros]

Hi all, 

I would lik to ask if there is a funcion that do the below. 

I want to check if one shell belong to a table array and also if another shell bellog to the same array and if this two are true to give me a number that is next to him.

as an example 

I want to check the A2 and the A3 if the belong to a different excel file table and if they are both true to give me the number that is 2 sheets next to the A2 number

thank you for your help

[#2]

Hi @tkollaros,

In the screenshot below, I created a table "table1" from cell D1 to F13. 

Then in cell B2, I added this formula

=IF(AND(IF(COUNTIF(Table1,A2)=1,TRUE,FALSE),(IF(COUNTIF(Table1,A3)=1,TRUE,FALSE))),2," ")

So if I type a number in cell A2 and A3 that exists in my table, cell B2 returns "2". If not, it returns nothing. 

[#3]

@Bennadeau 

Cosmetic comment:

=IF(COUNTIF(Table1,A2)*COUNTIF(Table1,A3),2," ")

shall work same way