Hi there,
I have a vlookup to pull in sample results, but occasionally we will have the same P# with multiple results, and I only would like to pull in column G (Sample Status) from the latest result if there are multiple samples with the same P#. Any suggestions? My current Vlookup is as follows (column O in another worksheet lists P#).
In the example below, I would want the vlookup to show "Requested Pending Result" (since it was the latest "recevied date" until we have a date in colunmn F, and then to pull in column G once we have a result date. Would this be possible?
=IFERROR(IF(VLOOKUP(O:O,SAMPLES!A:F,6,0)="","Requested Pending Result",VLOOKUP(O:O,SAMPLES!A:G,7,0))," ")
<tbody>
</tbody>
I have a vlookup to pull in sample results, but occasionally we will have the same P# with multiple results, and I only would like to pull in column G (Sample Status) from the latest result if there are multiple samples with the same P#. Any suggestions? My current Vlookup is as follows (column O in another worksheet lists P#).
In the example below, I would want the vlookup to show "Requested Pending Result" (since it was the latest "recevied date" until we have a date in colunmn F, and then to pull in column G once we have a result date. Would this be possible?
=IFERROR(IF(VLOOKUP(O:O,SAMPLES!A:F,6,0)="","Requested Pending Result",VLOOKUP(O:O,SAMPLES!A:G,7,0))," ")
A | B | C | D | E | F | G |
FORMATTED_PO | SAMPLE_NO | SMPL_DESC | REQ_DATE | RCVD_DATE | RESULT_DATE | SAMPLE_STATUS |
P-8857-A | 33764 | Arrival Samples | 7/5/2018 | 7/9/2018 | PENDING | |
P-8857-A | 33751 | Arrival Samples | 6/28/2018 | 7/3/2018 | 7/5/2018 0:00 | REJECTED |
P-8857-A | 33750 | Arrival Samples | 6/28/2018 | 7/3/2018 | 7/5/2018 0:00 | REJECTED |
<tbody>
</tbody>