V look up

Hi Kate,


Thank you for your question.

The difference between the true & false range lookups are defined by whether you want the lookup function to find the exact lookup value (false) or an approximate match which must be less than or equal to the lookup value being used (true).

Please find below a link that will give an example of using the true and false range lookup.


http://www.mvps.org/dmcritchie/excel/vlookup.htm


If you require further assistance, please reply to this post.


Kind Regards