How to do recursive searches in Excel

Hi,
I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet. If the content of a cell in the first sheet is found in the cell of the second, I need to be able to output a related cell from the second row.

I have the following "code", but need to make it into a VBA Macro, as I am not familiar with the syntax...

Variables
ServerRowNumber = 0
ServerName = ""
AppRowNumber = 0
AppServerCell = ""
AppCell = ""


For ServerRowNumber = 2 to 991
ServerName = Worksheets("Servers").Range("A'ServerRowNumber'").Value
For AppRowNumber = 2 to 339
AppServerCell = Worksheets("Apps").Range("B'AppRowNumber'").Value
If AppServerCell contains ServerName
Then
AppCell = Worksheet("Apps").Range("A'AppRowNumber'").Value
Write ServerName + ";" + AppCell
Else
Write ServerName + ";" + "**No Apps Found**"
Next AppRowNumber
Next ServerRowNumber

Any help gratefully received.