vlookup

[Relentless]

When i use the vlookup function, it is returning the data in the row
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
value of 200, not the 300 it should return for St Francis.

St Bonaventure 200
St Francis 300

Any help is MUCH appreciated

 

[nuver]

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)