vlookup-returning the data in the row

When i use the vlookup function, it is returning the data in the row 1 ABOVE the row it should be pulling the data from. E.g. VLOOKUP(K345,$A$4:$F$336,3) and k345 is St Francis, it is returning a value of 200, not the 300 it should return for St Francis.

St Bonaventure 200
St Francis 300

Any help is MUCH appreciated.

Try adding false at the end of the formula as listed below. What is happening is your vlookup is looking for the first closest match. By adding false at the end it will look for the exact match. Hope this helps.

Ed

VLOOKUP(K345,$A$4:$F$336,3,false)