I am using Excel 97.

I have a range which is named "status"

When the criteria is matched below I am wanting to place it in different
places on a spreadsheet, but it doesn't always work particularly when there
are similiarities in the team name.

For example:

If team = Range("Status").Find("Mansfield Town 2002") Then
'do something
End if

If team = Range("Status").Find("Mansfield Town 2003") Then
'do something
End if

If team = Range("Status").Find("Mansfield Town") Then
'do something
End if

Can anyone offer me some code which is a more reliable way of picking up the
correct team?

Thanks
--
Mark A Whitehead