Thank you for the suggestion! I think VLOOKUP will meet my needs but I'm having an issue working with it.
I am getting the value "#REF!" after inputting the code.
The goal is to lookup the UPC in Column 1 and then pull the name and other information associated with the column of the UPC.
Here is my code.
So A5 is the UPC for the item listed in the Sample Recipe.
'Base Inventory Sample.xlsm'!Table2[Column1] Is the spreadsheet and column to reference to find the UPC code.
",2," is the value in the second column that I want to pull. In this case, it should be the name "Butter"
"FALSE" means that I only want to look for the exact value.
Am I doing this right?
I have attached a sample Base Inventory and a Sample Recipe for reference.
To explain my sheets in a little more detail, I also have a macro running to record the date that the price of each ingredient was updated. It records this value a couple columns over on the same row as the ingredient. Furthermore, the Recipe references the Base Inventory for prices of ingredients and then once it has calculated the total cost of the recipe, that number is linked back to the Base Inventory sheet labeled "Prep" so that I have the cost of the prepped ingredients in the Inventory sheet as well.
Let me know if you have any more questions. I really appreciate any and all help.
These sheets have been my babies that I've worked on for the last year and getting this sorted would be so exciting for me!!
EDIT:
I found that if I change the lookup to the entire table, the VLOOKUP works correctly. Now, my problem is that my table will continue to grow as I add ingredients. How do I make sure that the table referenced will grow as well? Is there an End of List function or something that determines I just want to look at all the data in the table regardless of table size?
Bookmarks