Alternative to using Excel DataSink with VLOOKUP?

Hi Liam,

Thank you for your post! If you use Groovy DataSource or DataSink it can be more customizable. 

To get started with Groovy in ReadyAPI, please refer to the following links: 
Groovy Data Source: https://support.smartbear.com/readyapi/docs/testing/data-driven/types/groovy.html
Groovy Samples: https://support.smartbear.com/readyapi/docs/testing/scripts/samples/index.html

You can also use the DataSource and DataSink of the 'File' type - they can read and write from a text file (for example, .csv): https://support.smartbear.com/readyapi/docs/soapui/steps/data-sink.html