I have a problem with the vlookup and I have seen discussions before that shows how to fix this but I cant find it again.
1 Larry 22
1 Mike 22
5 Adam 10
4 John 11
3 David 15
1 Larry 22
2 #N/A #N/A
3 David 15
4 John 11
5 Adam 10
I need this to show all my number instead of N/A.
Can anyone help me with this? Rigt now I am using vlookup =VLOOKUP($A9,$A$1:$C$5,2,FALSE)
