Dynamic data source for vlookup

[Sirishaj]

Hello,

I have an excel spreadsheet (A) that is going be constantly updated with new data. I need to reference this spreadsheet to perform some calculations using Vlookup in another spreadsheet (B).

Is there a way that spreadsheet B would constantly update itself when a new data entry is made to A?

 

[danzon]

Create a dynamic named range and reference that name in your vlookup formula

Excel Names -- Excel Named Ranges

 

[Sirishaj]

Thank you for the reply. Is there a way I can print/display a named range in another workbook. I just need one column from workbook A in workbook B, that forms the basis of my Vlookup. Since A is updated frequently, I want the same column in B to dynamically update.