-
Notifications
You must be signed in to change notification settings - Fork 24
Open
Description
},
{
"id": 57771,
"instruction": "How do I determine in Excel that if a value from one row array matches a reference cell value, then the result should be the corresponding value from a second row array, but if it doesn't match, the result should be a different specified cell value? The precise scenario and table are provided in the attached spreadsheet. Matching cells in row arays, under specific condition If one of the values in the row aray [F3:J3] is equal to the core number in D3 Then the result is the matching value in [F7:J7] if none of the values in the row aray [F3:J3] is equal to the core number in D3 then the result is D7 In the table hereabove, J3 = D3, therefore the resul is J7 Comment :yes, I3 - D3 matching value is I7",
"spreadsheet_path": "spreadsheet/57771",
"instruction_type": "Cell-Level Manipulation",
"answer_position": "K4"
},
Should be J5
Metadata
Metadata
Assignees
Labels
No labels