Hi all,
Trying to figure out how to flag whether data from Sheet1 B1 can be flagged in C1 whether it is a true statement from Sheet2. For example I have a table with customer's favorite number in Sheet1 and I am trying to flag in the C1 cell if it is a Fibonacci, prime and/or square number.
Can anyone help me? When I have used LOOKUP and IF statements it comes up with #SPILL!
Sheet 1 - table
Sheet 2 - not in a table. Should it be in a table?
Trying to figure out how to flag whether data from Sheet1 B1 can be flagged in C1 whether it is a true statement from Sheet2. For example I have a table with customer's favorite number in Sheet1 and I am trying to flag in the C1 cell if it is a Fibonacci, prime and/or square number.
Can anyone help me? When I have used LOOKUP and IF statements it comes up with #SPILL!
Sheet 1 - table
Sheet 2 - not in a table. Should it be in a table?