I have 3 columns of non-consecutive data in several rows.

For example:

Column 1 Column 2
Column 3

Widget A Widget A Part 1 100
Widget B Widget B Part 1 125
Widget C Widget C Part 1 175
Widget D Widget D Part 1 225
Widget A Widget A Part 2 250
Widget E Widget E Part 1 300
Widget F Widget F Part 1 325
Widget A Widget A Part 3 50
Widget F Widget F Part 2 500
Widget D Widget D Part 2 450

Step 1: On a new spreadsheet tab, I need a formula to extract the
description of column 2 for the second smallest value of "Widget A" (i.e.
description in column 1). That is, the answer would be Widget A Part 1.

Step 2: I also need a formula (to be placed in the column next to the
formula required in step 1) to extract the second smallest for the answer to
step 1. That is, the answer would be 50.

The index instruction appears to be the function required for step 1 and 2.

Index (a2:c11, ?????, 2)

The trouble I am having is establishing the need for 2 criteria to be true
for the row designation in the index formula.