ms excel training london - Vlookup

Resolved · Low Priority · Version Standard

Tue 9 Jan 2007, 16:58 Delegate Katie said...

Katie has attended:
Excel Advanced course

Vlookup

What's the difference between using 0 and 1, or true and false?

Wed 10 Jan 2007, 13:50 Trainer Tom said...

RE: vlookup

Thanks for your question Katie. There is no actually difference as 1 is True and 0 is False in Excel's reference. True and false are just easier for us.

Regards

Best Training

PS Don't forget to recommend our forum to collegues, friends and family.

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips

ms excel training london - Vlookup

Vlookup

RE: vlookup

Excel articles

Excel tip:

Conditional Formatting in Excel 2010