In worksheet X, there is a list of items starting in A1 that read something like this “78. Blah blah blah”, “56. Etc.” and so on. In worksheet Y there is a list in A1 that reads, “SE5r 3.50 0.555 0.666” and "SE78 0.4 0.98 1.4” in A2. There are dozens of item numbers and they are all out of order.
What I want to do is to keep “78. Etc” in worksheet X but find the item that starts with SE78 and match the numbers that come after it to the other worksheet. So my final product for the first row would be: A1 (78. Blah blah blah) B1 (0.4) C1 (0.98) D1 (1.4)
This is difficult for me partially because in worksheet Y the item number and numbers are all in one column instead of the multiple ones I’d like for them to be in. But I wouldn’t mind suggestions of how to simply match the numbers up by the item numbers – I’m pretty new to this. Thank you so much!
Bookmarks