Home > Uncategorized > daily 06/22/2015

daily 06/22/2015

    • Because VLOOKUP is not the only lookup formula available in Excel, and its numerous limitations might prevent you from getting the desired result in many situations. On the other hand, Excel’s INDEX MATCH is more flexible and has certain features that make it superior to VLOOKUP in many respects.
    • The Excel INDEX function returns a value in an array based on the row and column numbers you specify. The syntax of the INDEX function is straightforward:
    • If both row_num and column_num parameters are used, the INDEX function returns the value in the cell at the intersection of the specified row and column.
    • The Excel MATCH function searches for a lookup value in a range of cells, and returns the relative position of that value in the range.
    • Let me remind you that the relative position of the lookup value (i.e. a row or/and column number) is exactly what you need to supply to the row_num or/and column_num argument of the INDEX function. As you remember, the INDEX function can return the value at the juncture of a given row and column, but it cannot determine which exactly row and column you want.
    • When deciding which formula to use for vertical lookups, the majority of Excel gurus agree that INDEX / MATCH is far better than VLOOKUP.
    • And then there’s the previously unknown “super henge,” a monument located just two miles from Stonehenge. Scans suggest that each buried stone is about three meters (10 feet) long and 1.5 meters (5 feet) wide. The stones are positioned horizontally, not vertically, but it’s conceivable that they originally stood upright like other standing stones. The archaeologists suspect they were brought to the site shortly before 2,500 BC.
    • I’m going to go off on a little tangent here. Because I’m sick of everyone who havent been staying in there own lane recently.

Posted from Diigo. The rest of my favorite links are here.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: