microsoft excel courses - V Lookup

Hi Lucy,

Thanks fot the question, the difference between the TRUE and FALSE setting is:-

If you put TRUE the computer will look for anapproximate match to your generator. The first column of your array must be in order and it will go down the list until it finds a point where the match will stop. For example, if your generator is "10000" it will go down the list until it finds 10000 or anything more than that and it will stop.

If you use the FALSE option it will find the exact match and your first list doesn't have to be in order.

I hope that helps

Tracy