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 ...
Hi Emili,
For the date located as on your screenshot you may use something like
=INDEX($G$3:$I$10,MATCH($A3,$G$3:$G$10,0),3-(INDEX($G$3:$I$10,MATCH($A3,$G$3:$G$10,0),3)="--"))
First MATCH finds the row there the ID is located, and from the column number within the range for the second RESULT we deduct 1 if nested INDEX/MATCH finds "--" here - thus use second column, or RESULT1
and in attached file