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)
Yes this looks like what i'm looking for but i can't seem to test it because i get this annoying ' sign before formula that seem to break it and i don't know how to remove it.
PS. Just deleting it doesn't work since it always shows back up upon finishing the formula.