ExcelBanter - Vlookup in different worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup in different worksheets (https://www.excelbanter.com/excel-worksheet-functions/60129-vlookup-different-worksheets.html)

ErwinR

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

Roger Govier

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?

All times are GMT +1. The time now is 06:42 PM.