Reading Values from another sheet

[Raabi]

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:

=CELL("value",sheet2!$B$Row())

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

[Catalin.B]

You can try this formula,

=HLOOKUP(Sheet1!A38;Sheet2!A1:E38;38;FALSE)
but if the value from Sheet1!A38 is not found in Sheet2!A1:E38 range, this formula will show #N/A error. There is another method, but you have to tell first if this is what you need.

[Catalin.B]

Note that the formula searches the value from Sheet1!A38 in the first row of Sheet2!A1:E38 range