Revision history [back]

The method to extract two particular values from a column while having another column with a shared value is to use a combination of the IF and INDEX functions.

Here are the steps:

1. Identify the columns that contain the shared value and the values to be extracted.
2. Create an IF formula that checks whether the shared value in the first column matches the desired value.
3. Use the INDEX formula to extract the values from the second column corresponding to the matched rows in the first column.

Here's an example formula:

=INDEX(B2:B10,IF(A2:A10="Shared Value",ROW(A2:A10)-ROW(A2)+1))

This formula will extract values from column B that correspond to the rows where "Shared Value" is found in column A.