Forum Discussion
Solved
VLOOKUP Error with inventory referencing
I am attempting to set up a vlookup function based on a SKU/MPN code. I have a product list from my supplier that has all the inventory updated on a weekly basis. And I have an exported product list ...
The #REF! is coming from the reference to a single column in the table. 3 is the column index but there's only 1 column in the provided table array.
Are you trying to return the Quantity on Hand? If so, you could use XLOOKUP:
=XLOOKUP(G3,_03022023_2[MPN],_03022023_2[Quantity On Hand])
The #REF! is coming from the reference to a single column in the table. 3 is the column index but there's only 1 column in the provided table array.
Are you trying to return the Quantity on Hand? If so, you could use XLOOKUP:
=XLOOKUP(G3,_03022023_2[MPN],_03022023_2[Quantity On Hand])- Yes! Thank you that worked!
- Glad it worked. You're welcome!
