#1
|
|||
|
|||
Reading Values from another sheet
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: Code:
=CELL("value",sheet2!$B$Row()) Any help will be highly appreciated. Raabi |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Note that the formula searches the value from Sheet1!A38 in the first row of Sheet2!A1:E38 range
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cursor in reading pane | Danny DeLoach | Outlook | 2 | 08-16-2011 11:58 AM |
Reading a message header | papaworx | Outlook | 5 | 04-25-2011 05:52 AM |
Reading pane (pain!!!) | Angus | Outlook | 3 | 04-17-2011 05:38 PM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |