User Profile
Luke_Hively
Copper Contributor
Joined Jan 24, 2022
User Widgets
Recent Discussions
VLOOKUP Between two CSV files
Hello, I am trying to use a vlookup function to between two of my workbooks to insert the price into column I in the products 2023 workbook. My current formula is =VLOOKUP(E2,'PSR2-2023-11-08.csv'!$A$2:$G$199228,7,FALSE) I'm am unsure of what the problem, I use the function pretty regularly and it may come down to formatting. Any suggestions would be appreciated. Thank youRemove number from a text string
Hello, I am trying to remove a number from the text string of the description of my products for my online store. The number is GTIN used by search engines. In Column J is the where the products are located. I filtered the column using the Text filter "contains" UPC. I was attempting to use ( LEFT,RIGHT,MID and Search but have no luck) In the image I highlighted the number I am trying to take out of the description ( it can be 12-13 characters long). I need that number to appearing in column BT. I attached the file as well if that is helpful. Thank you!Do I need to write an IF Then function with Vlookup nested?
Hello, I am trying to update the cost column by pulling the new cost from another work book. I had tried to use a VLOOKUP function but not all skus in column A appear in the other sheet. My question is how would I write and If then function with VLOOKUP nested to pull the price when the skus match and leave it as it is if it doesn't appear on the other workbook? I am currently working on windows 10. Thanks!Adding a formula after brackets
Hello, I am currently working on windows 10 and have selected an example cell of the one I would like to edit. I am struggling to insert a vlookup formula to pull a price from another workbook after the "[ADD} ." This is an export from a website template the the "[ADD]" function needs to stay for the reimport process. Any suggestions would be appreciated thank you
