Advance Excel

Learn how to add VLOOKUP formulas in different rows and columns, using excel 2013 it’s most important function for creating different reporting and dashboard of project plan.

Search for specific information in your spreadsheet. For example, if you have a list of items with prices, you could search for the price of a specific item.

• Enter formula in your specific location where you search the price of the Item.
• =VLOOKUP(H7,
• H7 is a location where you enter the Item name and VLOOKUP auto find the item price.
• Then select the area of the item and price.

• =VLOOKUP(H7,C7:D12,2 (C7:C12 is specific area) 2 is a column number.

• =VLOOKUP(H7,C7:D12,2,0) 0 is used to False or exact match.

So if you want some complex example, than download our free template and overview how to use this formulas in it.

Check out how you can change color in table using alternate highlight technique and apply formula? In given pictures you can seen “new formatting rules” so read it before apply in any table. In 2^nd image you can seen conditional formatting, Format and apply to areas, so let’s start.

• First select rows and columns of the table you want to format it.
• Go to Conditional & formatting dialog (Manage Rules> New Rules> Use a formula to determine which cells to format.
• Now, if you want to highlight alternative rows type this formula.
  =MOD(ROW(),2)=0
• If you want to highlight alternative columns type this formula.

=MOD (COLUMN (), 2) =0

• Click Format Button to change format (Color, Text Style etc.).
• Click Ok Then Click Apply.

So contact with us for more tips and tricks about advance excel 2016.