Sep 10 2020 11:57 PM
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
Sep 11 2020 07:25 AM
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.
Sep 11 2020 07:31 AM