About IF statement in excel

[postonbenito]

Can any one shed some light on writing an if statement to compare a cell to a range of cell. What I want to do is compare a name to a list of names on a separate spreadsheet and mark it if it finds match on that list. Thanks in advance.

[BurgoEng]

For example the name you are looking for is in G1 and the list is Sheet2 - A1:A12

=IF(COUNTIF(Sheet2!$A$1:$A$12,G1)>0,"Present","")