Forum Discussion

Copper Contributor

Nov 02, 2020

VLOOKUP for 1000 inventories items

I have an inventory column with 1000 items, each in its own row in a worksheet. Each item has its own price in a different column using the same worksheet. I want to use VLOOKUP that when an inv...

excel

mathetes

Silver Contributor

Nov 02, 2020

Gary_Naskrent

It sounds as if you don't fully understand how VLOOKUP works. If on your "main worksheet" you are entering a Product Code (or some other identifier) in, say, sell A2, you should be able to put VLOOKUP in to cell B2 and have it search through all 1,000 rows of the inventory list in the other worksheet.

It also might be helpful if you research using XLOOKUP, a newer, more powerful and flexible function.

In the absence of seeing your actual workbook, let me point you to a web resource that can help you with how these functions are best deployed. If you still are having troubles, please come back and post either your actual workbook or a good facsimile of it (in Excel, not an image).

VLOOKUP https://exceljet.net/search?query=vlookup

XLOOKUP https://exceljet.net/search?query=xlookup