Name Range

[neerajagarwal2050]

Hi,

While using name range along with vlookup, the problem which I face is if I copy and paste the vlookup formula to next COLUMN, formula bar shows the table name(name range) only. I get confused whether it will automatically select the next column or not.

Thanks in advance!!

 

[Somendra Misra]

Hi Neeraj,

Can you share a sample file.

Regards,

 

[neerajagarwal2050]

Dear Sir,

Appreciate your help.

Problem has been resolved. I unticked :use table names in formulas from advance options.