Greetings!
I am trying to copy over a file path from one sheet to another depending on if Sheet1's Location column matches Sheet2's Name column. If they match then I would like the Path column record to be copied over to the new sheets in the appropriate row.
Example dummy data is attached.
Not sure that I understand however I'll make a proposal.
The formula for cell E2 on Sheet2 could be something like: =INDEX(Sheet1!A2:A5,MATCH(A2,Sheet1!E2:E5,0))
The formula for cells E3:E5 could be: =LEFT(E2,SEARCH("|",SUBSTITUTE(E2,"/","|",LEN(E2)-LEN(SUBSTITUTE(E2,"/",""))))-1)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks