Forum Discussion
Solved
Suggestions in Shortening a Formula
I have a csv file, that I get on a daily basis, that contains data for adding/updating products on my website. The 2 particular columns of data that I am dealing with in this inquiry is the Product ...
=INDEX('proper names'!$B:$B,MATCH(LEFT('actual data'!B2,3),'proper names'!$A:$A,0))For the actual layout of your data you can try INDEX and MATCH.
I'm not sure I understand so let me show a short version of what I am dealing with. The first image is a portion of the actual data whereas I need to fill in the Manufacturing column with the correct name. The second image is a list of proper names with corresponding 3 letters. It's also important that it's the first 3 letters of the product number because others may have the same within the rest of it.
=INDEX('proper names'!$B:$B,MATCH(LEFT('actual data'!B2,3),'proper names'!$A:$A,0))For the actual layout of your data you can try INDEX and MATCH.
I was trying to do it within the same file but that will work.
Thanks for your help!