Excel 2000, VLOOKUP problem

Question

question

DavidPage-7809 asked May 7, '22 emilyhua-msft commented May 10, '22

Excel 2000, VLOOKUP problem

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?

office-excel-itpro

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-05-09T05:59:41.703Z

emilyhua-msft answered May 9, '22 emilyhua-msft commented May 10, '22

Hi @DavidPage-7809

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.

25.jpg (18.9 KiB)

24.jpg (21.8 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft · May 10 at 07:24 AM

Hi @DavidPage-7809

I am glad that your issus has went away. You found out that you were not including the cell range with the target sheet name.

Can you accept the helpful information as an answer?
This action can help other users on Q&A forum who encounter the same issue.
Thanks for your understandings.

1 ·

question