Vlookup Not Working with Dynamic Named Range

[hrayani]

Hello Friends,

I am trying to Vlookup from one workbook to another. Problem i am having is when i use a named range in the Vlookup - it works fine. But when a dynamic name range is used in Vlookup then its giving #REF! & to make the Vlookup formula work i have to open the mother source file where the original data is....

Name range refers to below works fine

=RunningOrder!$B$3:$O$56

But Name Range refers to below does not work

=OFFSET(RunningOrder!$B$3,0,0,COUNTA(RunningOrder!$B:$B),14)

Any help would be appreciated,

Regards,

Humayun

 

[Aladin Akyurek]

Dynamic named ranges do not work from workbook to workbook.

 

[hrayani]

Thanks Aladin for the reply.....

In that case.... shall i use =RunningOrder!$B:$O instead of=RunningOrder!$B$3:$O$56

because the list will be increasing all the time....

or can we use an offset formula in the Vlookup formula ???

 

[Aladin Akyurek]

Thanks Aladin for the reply.....

In that case.... shall i use =RunningOrder!$B:$O instead of=RunningOrder!$B$3:$O$56

because the list will be increasing all the time....

Right.

or can we use an offset formula in the Vlookup formula ???

No.

 

[hrayani]

Thanks

 

[Aladin Akyurek]

Thanks

You are welcome.