Is there a Find command to look for values in a specific column/sheet?

[ou81aswell]

I have a workbook with a number of sheets. I'd like to be able to select a cell value in one sheet and then search for it in a specific column in a specific sheet.

I don't want to use vlookup for a variety of reasons, the main reason being I want it to be as interactive and adhoc as possible.

What I'd really like to be able to do is use the Find command but restrict it to a specific sheet (which I could select from a list of all open sheets) and a specific column.

Is there a way to do this in Excel?

I'm using Excel 2010 x64 on Win 7 x64.

Thanks!