Hello

Welcome to the world of vlookup.

You need to understand how vlookup works:
VLookup(Value to lookup (PLC for instance), the range or table the value may be found in, the column number across you need to locate the value, false means there will be no duplicates in the search column and true means that there will be duplicates in the search column.)

If it is any consolation 40 + columns can be achieved by the third attribute of the function to match the column you want to search.
Data structure will be the key to designing a suitable solution.

Kind regards

Steve