| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup in different worksheets
Hello. How can I get in a worksheet all the values of let's say cell A5 or column B from several different worksheets? -- ErwinR ------------------------------------------------------------------------ ErwinR's Profile: http://www.excelforum.com/member.php...o&userid=29595 View this thread: http://www.excelforum.com/showthread...hreadid=492974 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup in different worksheets
Hi
Do you mean =SUM(Sheet1:Sheet10!A5) This will sum the values of cell A5 across all 10 sheets. Regards Roger Govier ErwinR wrote: Hello. How can I get in a worksheet all the values of let's say cell A5 or column B from several different worksheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with vlookup across multiple worksheets | Excel Worksheet Functions | |||
| Vlookup multiple worksheets | Excel Discussion (Misc queries) | |||
| vlookup multiple worksheets | Excel Worksheet Functions | |||
| Can vlookup or hlookup look to other worksheets within a workbook. | Excel Worksheet Functions | |||
| vlookup over multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
