advanced excel ms training - v look up

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - V Look Up

advanced excel ms training - V Look Up

resolvedResolved · Low Priority · Version Standard

Laura has attended:
Excel Advanced course

V Look Up

Should I put TRUE or FALSE? Whats the difference?

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


 

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips


Server loaded in 0.09 secs.