excel computer training london - VLOOKUP function

Hi Katie

Thanks for your question.

I think the answer lies in what you enter in for the 'range lookup' part of this function. This is the last part of the function where you enter in true or false.

If you enter in true for this part of the function, then the vlookup function will find the nearest possible match and display this. If you use true then the result that is displayed does depend on how the information is sorted - you do need to put it in some kind of order (alpahabetical or numerical) for it to work.

If you enter false for this part of the function, then the vlookup function needs to find an exact match. If you enter false then the result is not dependant on the information being sorted in a particular order.

I hope this helps you.

Amanda