Hi,

It's my first post and I am a novice in VBA. I know my issue is simple one
but I cannot come out with the solution. Maybe some one can help.

What I am trying to accomplish is to search trough an entire column in the
first sheet1 (A:A) for a specific value (let say "a") and return the cell
value from column "C" of the same row in sheet2.

Ex:

Sheet1 Sheet2 (the same workbook)

A B C A B C

a 2 4 4
1 5 6
8 7
a 9 6

So in this case the result of the search is shown in Sheet2


I know that I can use the vlookup function but I need to look for more than
one value in the column and return the cell values from each row.

Thanks in advance