Actually, you can use this formula:

to get the name of the first vendor from Payables and

to get the 2nd vendor name. I created the formulas by using "Get external data" to link from the payable transaction to vendor master to get the name, then pasted the resulting formula into the Inventory View and changed the {Vend # (2)} field to the requisite Inventory field.

While it is easier to generate these formulas using cut and paste, you can actually code to get any external data element you want from any table.