IF Function
The formula seems to be an array formula checking if name in A10 appears in
any of A1:A7. If yes it returns the row No, if not, it returns FALSE.
To try it select range B1:B7, enter formula and confirm it with
Ctrl+Shift+Enter!
Regards,
Stefi
€˛Sandeep Jangra€¯ ezt Ć*rta:
Dear Stefi,
I have a list of names range A1:A7. Someone gave me a formula
=IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)). What does it mean $A$1:$A$7=$A$10.
"Stefi" wrote:
You should give an example of the task!
Regards,
Stefi
€˛Sandeep Jangra€¯ ezt Ć*rta:
D'all,
Can "if " search values in a list/range? If yes plz help with an example.
|