VLOOKUP Not working

Lauryn Vogt

I have a sheet of all our products for sale. We are introducing new pricing in Jan. 2024. I have the new pricing in a smaller sheet that I imported in from Excel. The first column of that sheet is our Core Stock Number, then the pricing column, for example, Retail, Sale, Qty Discounts, etc. I want to use a VLOOKUP to put the new pricing from the imported sheet into our Current Product Sheet. I am getting the #UNPARSEABLE error. I am unsure what I am doing incorrect. A screenshot of my formula is attached.

I know I will have another issue once I get this to work. We use something like a Parent Child Relationship on our items. For Example, we may have 3 lines in our sheet with the same Core Stock Number, but then a different component. We need the pricing to only be on the "Parent" row. If I insert the VLOOKUP as a Column formula, I am afraid it is going to be filling in pricing on all 3 rows that have the same Core Stock Number and not just our Finished Good - the sellable version. Screenshots are attached. Any ideas on how to write a formula to pull in pricing only on the Finished Good Line when we find a match on the imported pricing sheet?

Screenshot 2023-10-12 Formula.png

Screenshot 2023-10-12 item code.png

Nick Korna

Hi @Lauryn Vogt,

You don't need the square brackets [ ] around false in your lookup - these will definitely cause an error.

If the parent item is listed first, it should capture this item in the lookup. If that isn't the case, you can get round this by using an INDEX/COLLECT instead. Unfortunately I can't really say what this would look like without column headers on the respective sheets.

Hope this helps, but if you've any problems/questions then just post! 🙂