Vlookup display as N/A

[Chris1973]

Hi Guys

I posted previously regarding a N/A problem

For one or other reason using vlookup does the following happen

05581 010 000	EMPTY ASSORTMENT BOX	R -	1	R -
05581 010 000	#N/A	#N/A	1	#N/A
05581 010 000	#N/A	#N/A	1	#N/A
05581 010 000	#N/A	#N/A	1	#N/A

Only the top line display correctly, the rest keeps on showing n/a.

All the info is exactly the same as the top line, if tried actually every solution available but still no success

formula use: =VLOOKUP(B12;Pricelist!A3:B$550;2;FALSE)

 

[jasonb75]

Try making the references absolute, no guarantees that it will fix the problem but it's the only thing that stands out as a possible problem from your post.

=VLOOKUP(B12;Pricelist!$A$3:$B$550;2;FALSE)

 

[jasonb75]

If that doesn't work then it is likely that you have issues with some numbers formatted as text, which appears to have been the problem in your other thread.

 

[Chris1973]

Thanks Jason

This worked 100%