Hello everyone

I am seeking help from wizards in solving the following problem:

I have two Worksheets: "sheet1" and "sheet2".
In column "Value2" of the "sheet1", I need to put values from the corresponding row numbers and "event" column of the "sheet2".

I tried, in vain, a formula, in each cell of the column "Value2" of the "sheet1"; similar to the following Pseudo syntax:

Please note that the two sheets are fairly large and frequently updated; and therefore just pasting the values from sheet2 is not a viable solution.

Any help will be highly appreciated.

Raabi