Hi All,
Have used many solutions that have been posted on this forum for other tasks before, but the first time I'm posting as I can't find quite what I need!
Two sheets to my workbook: Sheet One contains single reference identifiers in each cell of column A (i.e. A1 = C10, A2 = R4). Column B is for returning the Part Number from the second sheet (where I need a formula)
Second sheet (BoM) contains column A full of cells with text strings containing the identifiers (i.e. A1 = R23 R37 R41 R43, A2 = R4, R61, R18) and column B containing the Part Numbers relating to those references.
Basically I need a formula to find the part number for the single reference identifier. I have tried: =VLOOKUP("*"&A2&"*",BoM!$A$2:$B$62,2,FALSE) but the problem is that it finds the first instance of a string. Using the cell contents examples above, that means if I was searching for R4 then the Part Number in B1 would be returned as the formula sees R41 before it sees R4.
Hopefully that makes sense? I can't attach the actual document but have attached a couple of pics for reference!
Cheers,
Tom
Have used many solutions that have been posted on this forum for other tasks before, but the first time I'm posting as I can't find quite what I need!
Two sheets to my workbook: Sheet One contains single reference identifiers in each cell of column A (i.e. A1 = C10, A2 = R4). Column B is for returning the Part Number from the second sheet (where I need a formula)
Second sheet (BoM) contains column A full of cells with text strings containing the identifiers (i.e. A1 = R23 R37 R41 R43, A2 = R4, R61, R18) and column B containing the Part Numbers relating to those references.
Basically I need a formula to find the part number for the single reference identifier. I have tried: =VLOOKUP("*"&A2&"*",BoM!$A$2:$B$62,2,FALSE) but the problem is that it finds the first instance of a string. Using the cell contents examples above, that means if I was searching for R4 then the Part Number in B1 would be returned as the formula sees R41 before it sees R4.
Hopefully that makes sense? I can't attach the actual document but have attached a couple of pics for reference!
Cheers,
Tom