Forum Discussion
Vlookup N/A error
Does it work if you change the 2nd formula to:
=VLOOKUP($A2,'A&D Form'!$A$1:$R$2977,3,FALSE)
My assumption is that $A2 and $A3 are different entries. Maybe in $A2 you have "participantE" and in $A3 "participantE " with a space at the end.
=VLOOKUP(A3,$E$3:$G$15,2,FALSE)
Does it work if you change the 2nd formula to:
=VLOOKUP($A2,'A&D Form'!$A$1:$R$2977,3,FALSE)
My assumption is that $A2 and $A3 are different entries. Maybe in $A2 you have "participantE" and in $A3 "participantE " with a space at the end.
=VLOOKUP(A3,$E$3:$G$15,2,FALSE)
OliverScheurich thank you so much for your reply! I have worked out thr problem!
It wasn't spaces at the end but I noticed the green triangles in the corner of some of the data - even though I set the whole column to the same type of data (number and I tried general). I managed to select all and resolve the error and it fixed the VLOOKUP. A silly mistake, but still learning!
Thank you! 🙂