Hi There, i am new to vba/macros. I have a worksheet (worksheet 1). In this worksheet i have a macro which needs a value from another worksheet (worksheet2).

In worksheet 2, i need to first find a value on the sheet ( i need to get row number). Once i get the row number i need to find a value for that row in another coloumn.

I tried basic VLookup (even with out using it VBA/Code) but could not manage to work.
Can some one please assist. Thanks