Hello all,

I have been toiling away trying to get this formula to pull what I need; I have attached an example workbook for your reference/to play with.

The formula I originally thought worked does not apply to a set of model numbers... you'll see in the sample from Cells A1:A3, there are examples (ES, DS, QS) of these model numbers as per the data in Sheet 1.

ES and DS numbers are functional with this formula; however, I've noticed that QS numbers are not properly retrieving data from the chart in Sheet 1. I know this is something to do with the placement of the relevant numbers in this case (in ES and DS, the relevant numbers are the 4th digit after the "."; in QS, the relevant number is 2nd digit after "."), however, after trying many different modifications, I can't get this formula to work!

Any advice is appreciated; thanks for checking it out.


sample formula.xlsx