Hi, this is likely a simple formula question for any veteran users.
Sheet1:
I have drawings listed in column A
I have tags, separated by commas, listed in column D (at times I could have upwards of 20 tags associated to one drawing)
Sheet2:
I have the same tags, listed individually, row by row, in column B
I have system names (associated to each tag) in column D
I need to write a formula that will fill out a new column (column F on sheet1) with all of the Systems associated to each Drawing. I expect that this needs to be done with VLookup but I'm not certain.
Bookmarks