Hello All
Please see attached
In H19- looks at the text in I19 and returns the part number from the table in yellow based on the string of text....
Paul
Hello All
Please see attached
In H19- looks at the text in I19 and returns the part number from the table in yellow based on the string of text....
Paul
I could not see any clues in H19 or I19 in both sheets to keep going forward...
Quang PT
Correct attachment is now attached
So you want to vlookup I15 in K15:L19 to get the part number?
=VLOOKUP(TRIM(I15),$K$15:$L$19,2,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks