hi all
i have a vlookup sum that is looking at a list of UK postcodes and then shows the data in the 2 columns next to it, its providing the right result some times but sometimes it seems to be chosing the cell above my result.
here are my 2 sums please let me know if there is anything wrong here or a better way of doing it
=VLOOKUP(B28,sheet4!A2:E10579,2)
=VLOOKUP(B28,sheet4!A2:E10579,3)
kind regards
rick
Bookmarks