Excel 2000, VLOOKUP problem

Question

I believe I am attempting to use VLOOKUP as described, however I am getting a #NAME? error I can't seem to resolve. I have a project worksheet which lists certain inventory item numbers in column A, and I am trying to look up the current price of those items on a master price list (which is on another worksheet) using the item number, not a cell reference. My formula is: =VLOOKUP(A1, ARINVT_E [the worksheet with the master inventory],9 [the column containing the current price]) If I use the wizard, I get the #NAME? error on the array_table line, even if I copy the master inventory list into the same workbook as Sheet 2. The list of inventory items is Column A of the master price list. What am I doing wrong?

Answer 1

Hi @David Page

Can you take some screenshots of the formula and the data on master sheet?
Please note, if there is any privacy information, you can cover it.

Then according to the article "How to correct a #NAME? error", I suggest you check whether "ARINVT_E [the worksheet with the master inventory]" in your formula is written correctly. Not just the writing format, the spelling, but also the data range.

Such as my sample, my "master sheet" is called "Sheet2".

The "project sheet" is called "Sheet1", and I need to add Sheet2! to point the range of the data source (From A2 to C4 on Sheet 2) in my formula.

Any updates, welcome to post back.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---