Chromecast app for my mac. • Watch Amazon Prime Video on your TV (and overcome Chromecast’s lack of compatibility with Amazon Prime) by casting through the Chrome browser • Share whatever’s on your screen with everyone in the room (vacation pictures, videos, work projects, status boards) • Show Albums from your Google Photos • Send presentations and slideshows from your Macbook on any HDMI screen cable-free • Put a Google Hangouts call onto a big screen so you don’t have to crowd around your laptop’s (relatively) small screen. = (E6,B5:C7, 2, FALSE ) This formula uses the value of cell E6 to lookup and retrieve the right cost in the range B5:C7. How this formula works This is a basic example of VLOOKUP in 'exact match' mode. The lookup value is B6, the table is the range B5:C7, the column is 2, and the last argument, FALSE, forces VLOOKUP to do an exact match. Look up information with VLOOKUP and HLOOKUP From the course: Excel for Mac 2016: Advanced Formulas and Functions. In this Excel for Mac 2016 update to his popular series, author Dennis Taylor. (Read why this is necessary ). If VLOOKUP finds a matching value, the associated cost will be retrieved from the 2nd column (column C). If no match is found, VLOOKUP will return the #N/A error.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |