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 function and i'm probably not using them correctly.
Tried and failed attempts:
=VLOOKUP($A2;CP:CP;CQ:CQ; [TRUE])
=VLOOKUP($A2;CP:CP;CQ:CQ; [FALSE])
=VLOOKUP(A:A;CP:CP;CQ:CQ; [TRUE])
=VLOOKUP(A:A;CP:CP;CQ:CQ; [FALSE])
=VLOOKUP($A2;CP:CP;CQ:CQ;)
=VLOOKUP(A:A;CP:CP;CQ:CQ;)
=IF($A2=CP:CP;CQ:CQ)
=IF($A2=CP:CP;CQ:CQ; [0])
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.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)
Previous issue was solved by clearing format
The formula you provided shows up as an error(red boxed)
Your sample file is too small, i can't see all the details. Can you attach a picture which shows the important data - without sensitive data - in a size similar to the picture of my previous post?
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.
