Forum Discussion
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 ...
Emily,
another lookup variation:
=LOOKUP(9^99,INDEX($H$3:$I$4,MATCH(A3,$G$3:$G$4,0),0))