Pipeline wall thickness lookup table
Thread Content
The pipeline wall thickness lookup function retrieves results automatically; two methods are used for this purpose. The first method makes use of the VLOOKUP function and MATCH function, while the second method employs WPS’s JS macros. Address: https://www.aliyundrive.com/s/ZbczSjjehT8
Good idea; it generates results automatically. But for tables with such limited data, it is still more accurate to look up the content directly within the table. After all, if you enter the wrong lookup term in VLOOKUP, no results will be produced. There is enough time for input, so that results can be found in the table.
INDEX MATCH