VLook up - named range from a separate workbook | Excel forum

Hi Paul,

Thank you for the question.

Vlookup:

Yes you can retrieve specific data from another workbook using the Vlookup function. Open both workbooks, create the function and when you need to add the Table_array range navigate to the source workbook and select the range. This will create an active link to the source file.

Range Name:

Named ranges in a worksheet are available in the whole workbook and also in other workbooks. If you want to refer to a named range in another workbook you must type the name of the workbook in Apostrophes and then Exclamation mark and then the range name.

see example 'workbookName.xls'!RangeName

I hope that this is what you need.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu