Need help with VLOOKUP and Nested IF Functions

I Need some help with a VLOOKUP Formula.  I have a spreadsheet where you dump results from samples. However sometimes Samples are tested twice.  So I need a formula that will look up the Sample ID ...