vLookup Excel 2013

[raf2013]

Hi,

I am trying to use vLookup with Excel 2013. I used to use it all the time with previous versions and I never had a problem.
The issue is as following:

I have two tabs in one Excel file. One has a list with different items and their prices (the pricelist), and the other one is to look up different items' prices according to their ID (the quotation tab).
On the pricelist, I defined a range called PriceListRange, which covers the whole information.
In previous versions of Excel, when I entered the range on the dialog box for the vLookup, I used to go to the pricelist tab, pull down the menu on the left (where the list of ranges appears), select the range, and the values were immediately transferred to the dialog box. When I try to do this with Excel 2013, instead of getting the list of ranges to choose one from, I get the list of Excel functions.

I tried to input the range manually (like A5:G116, for instance), but I can't drag the formula on the quotation tab when I need to do a long quotation. What happens then is that the row number changes, and therefore, the value of the cell is not correct).

Pls let me know whether you can help me.

Thanks a lot!

[:) Sixthsense :)]

When you are writing the formula just press the F3 which will show the list of Defined Names just select your desired Defined name and give ok…

[raf2013]

Hi Sixthsense,
Thanks a lot for your help. F3 is the solution to my problem.
Best regards!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

[Fotis1991]

raf2013

When you decided to put this question in Commercial Services section you had to pm to an on line Moderator to close this thread. So i do this now!

Also we have to say that the solution that you describe was offered by benishiryo there!