Unfortunately ExcelLink is not programmable to do what you mentioned.
You may be able to program an Excel Macro based spreadsheet to retrieve the data and the macro program can then decide which other data to pull based on the result of the first set of data it retrieved. However, you do need to write the code in Excel to execute the hostlink commands interaction with the PLC via TCP/IP (Ethernet or TLServer with USB-RS232 adapter)
The following web page is a bit old but does describe one Excel spreadsheet that we wrote before using Macro to send host-link command on the PLC and process hostlink response from the PLC:
http://www.tri-plc.com/ExcelLink/ewqtoolkit.htm
