I looking for help with a VLOOKUP formula for my spreadsheet. I am looking for the formula to be placed in the 'end wall template' tab. I would like to look up the rcc part number in the 'template' tab 'column B' that have the following criteria:
1) a unique 'detail number' (ie., 201)
2) a 'dash then alpha/number' after the first part the entire part number sequence '-I34V63, -I37V64, -I35V65
' (ie., TY2AF-282090-I34V63)
I also don't want blank rows to show up in the 'end wall template'. Out of the 84 part numbers, there is approx 30-40 part numbers that should show up in the 'end wall template' tab because those are the only ones that we need to show the data for. To make this more complicated I need 'columns I - N' to pull the appropriate data related to the correct detail number/rcc part number.
I am trying to have all the data entered into the 'template' and populate the other two tabs in this spreadsheet. The 'datasheet' tab is complete but the 'end wall template' tab is sort of complicated due to only some of the part numbers needing to show data.
I would also like help with taking the number entered into the 'template' tab 'column AC' converted into millimeters in 'column AD'. This is done by multiply AC by 24.5 and this converts inches to millimeters.