I have a spreadsheet that contains information on lot number sold, price,
settlement date and who the purchaser is. I have a second spreadsheet that
contains lot number, purchaser and settlement date.

I would like to be able to set up in the 2nd spreadsheet a formula so that
when a new lot number goes into the 1st it updates the second. The second
spreadsheet is sorted by Purchaser.

I was thinking possibly a comination of VLOOKUP and IF statements but am now
completely at a loss as to where to start!