Thu 20 Sep 2007, 16:44Delegate Laura said...
Laura has attended:
Excel Advanced course
V Look Up
Should I put TRUE or FALSE? Whats the difference?
Fri 21 Sep 2007, 07:09Trainer Katie said...
RE: V Look Up
Hi Laura,
Thanks for your question.
For VLOOKUP, the function looks like this:
=VLOOKUP(Search cell, data table range, compare column, match type)
For match type:
TRUE: for near match
FALSE: for exact match
e.g. searching references: names/price, you need exact match, so you'll input FALSE
e.g. searching for a brief estimate, you will put TRUE
Hope this helps. -Katie
