I want to paste the cell value of column F if Column A and Column E match.

For instance since A2 = E3, B/2 should be the output.

What formula should I use?

CodePudding user response：

You can use this formula =IFERROR(INDEX(F2:F5,MATCH(A2:A5,E2:E5,0)),"no result")

CodePudding user response：

What do you mean exactly? If the value in column A in row {i} is found in column E in row {j}, what do you want to be shown in column f row {j}. or should the result be shown in column F row {i}