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

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.

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