Forum Discussion
Solved
Noob needs help with function
The main job it should do: Fill column D with value from column CQ but only if value in A = CP Bonus: if there is no match between A and CP it should show 0 I have tried VLOOKUP and IF functi...
Souke555666 The formulas you mentioned in your initial posting used the semi-colon to separate the arguments. Try replacing the commas in the formula you were given by semi-colons.
Thus, like this:
=IFERROR(INDEX(CQ:CQ;MATCH(A3;CP:CP;0));0)
Bump
Still need help with this.
Still need help with this.
Souke555666 The formulas you mentioned in your initial posting used the semi-colon to separate the arguments. Try replacing the commas in the formula you were given by semi-colons.
Thus, like this:
=IFERROR(INDEX(CQ:CQ;MATCH(A3;CP:CP;0));0)
