METHOD MEDIA COMPUTER ACADEMY PRIVATE LIMITED

Add New Topic

Enter Topic Details

Select Topic

Topic Title

Video URL

Content Details

<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">Lookup
Function: - <span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">The
Microsoft Excel LOOKUP function returns a value from a range (one row or one
column) or from an array.<o:p></o:p><span style="font-family: Helvetica, sans-serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Syntax: -         <span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">=LOOKUP (value,
lookup_range, result_range)<o:p></o:p><table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="margin-left: 81.75pt; border: none;">
 <tbody><tr>
 <td width="128" valign="top" style="width: 95.75pt; border-width: 1pt; border-style: solid; border-color: black; padding: 0in 5.4pt;">
 Order ID<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 Product<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 Unit Price<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 Quantity<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10247<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Apples<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 14.00<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 12<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10249<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Oranges<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 9.80<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 10<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10250<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Banana<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 34.80<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 5<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10251<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Pears<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 18.60<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 9<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10252<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Grapes<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 42.30<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 40<o:p></o:p>
 </td>
 </tr>
</tbody></table><span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Ex: -           <span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">=Lookup (10251,A1:A6,B1:B6)<o:p></o:p>

<span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Result: -      <span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Pears<o:p></o:p>

Hlookup Function: - <span style="font-size: 14pt; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">The Microsoft Excel HLOOKUP function performs a horizontal
lookup by searching for a value in the top row of the table and returning the value in the same
column based on the index
number.<o:p></o:p>

<span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: black; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Syntax: -<span style="font-family: Helvetica, sans-serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">     <span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">=<span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">HlOOKUP (value, table,index no, approximate match)<o:p></o:p>

<p class="MsoListParagraphCxSpFirst" style="margin: 7.5pt 0in 0.0001pt 0.5in; text-indent: -0.25in; line-height: 16.5pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">v Value: - The value to search for in the first row of the table.<o:p></o:p>

<p class="MsoListParagraphCxSpMiddle" style="margin: 7.5pt 0in 0.0001pt 0.5in; text-indent: -0.25in; line-height: 16.5pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">v Table: - Two or more rows of data that is sorted in ascending order.<o:p></o:p>

<p class="MsoListParagraphCxSpMiddle" style="margin: 7.5pt 0in 0.0001pt 0.5in; text-indent: -0.25in; line-height: 16.5pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">v Index number: -The row number in table from
which the matching value must be returned. The first row is 1.<o:p></o:p>

<p class="MsoListParagraphCxSpLast" style="margin: 7.5pt 0in 0.0001pt 0.5in; text-indent: -0.25in; line-height: 16.5pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">v Approximate match: -Optional. Enter FALSE to find an exact match.
Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is
the default.<o:p></o:p><table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" align="left" style="border: none; margin-left: 6.75pt; margin-right: 6.75pt;">
 <tbody><tr>
 <td width="102" valign="top" style="width: 76.4pt; border-width: 1pt; border-style: solid; border-color: black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">Order
 ID<o:p></o:p>
 </td>
 <td width="101" valign="top" style="width: 75.55pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">10247<o:p></o:p>
 </td>
 <td width="94" valign="top" style="width: 70.45pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">10249<o:p></o:p>
 </td>
 <td width="102" valign="top" style="width: 76.4pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">10250<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">10251<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">20252<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">10253<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="102" valign="top" style="width: 76.4pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">Unit
 Price<o:p></o:p>
 </td>
 <td width="101" valign="top" style="width: 75.55pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">14.00<o:p></o:p>
 </td>
 <td width="94" valign="top" style="width: 70.45pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">18.60<o:p></o:p>
 </td>
 <td width="102" valign="top" style="width: 76.4pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">7.70<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">16.80<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">16.80<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">64.80<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="102" valign="top" style="width: 76.4pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">Quantity<o:p></o:p>
 </td>
 <td width="101" valign="top" style="width: 75.55pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">12<o:p></o:p>
 </td>
 <td width="94" valign="top" style="width: 70.45pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">9<o:p></o:p>
 </td>
 <td width="102" valign="top" style="width: 76.4pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">10<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">6<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">20<o:p></o:p>
 </td>
 <td width="80" valign="top" style="width: 60pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:8.2pt;mso-height-rule:exactly">40<o:p></o:p>
 </td>
 </tr>
</tbody></table> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><span style="font-size: 14pt; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Ex: -           <span style="font-size: 14pt; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">=Hlookup
(10251,A1:G3,2,False)<o:p></o:p>

<span style="font-size: 14pt; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Result: -      <span style="font-size: 14pt; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">16.80<o:p></o:p>

<o:p> </o:p>

Vlookup: - <span style="font-size: 14pt; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">The
VLOOKUP function performs a vertical lookup by searching for a value in the
first column of a table and returning the value in the same
row in the index no. position. <o:p></o:p>

<span style="font-size: 14pt; line-height: 115%; font-family: "Times New Roman", serif; color: rgb(51, 51, 51); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Syntax: -    =VLOOKUP ( value, table, index_number, approximate match)<o:p></o:p><table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="margin-left: 81.75pt; border: none;">
 <tbody><tr>
 <td width="128" valign="top" style="width: 95.75pt; border-width: 1pt; border-style: solid; border-color: black; padding: 0in 5.4pt;">
 Order ID<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 Product<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 Unit Price<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt;">
 Quantity<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10247<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Apples<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 14.00<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 12<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10249<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Oranges<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 9.80<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 10<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10250<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Banana<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 34.80<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 5<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10251<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Pears<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 18.60<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 9<o:p></o:p>
 </td>
 </tr>
 <tr>
 <td width="128" valign="top" style="width: 95.75pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt;">
 10252<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 Grapes<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 42.30<o:p></o:p>
 </td>
 <td width="128" valign="top" style="width: 95.75pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt;">
 40<o:p></o:p>
 </td>
 </tr>
</tbody></table>Ex:
-            =VLOOKUP(10251, A1:B6, 2,
FALSE)<o:p></o:p>Result :        "Pears" Returns value in 2nd column Ex: -            =VLOOKUP(10251,
A1:B6, 2, FALSE)Result :        "18.60" Returns value in 3rd column</blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">IF OR FUNCTION: -The IF
function can be combined with the <a href="http://www.techonthenet.com/excel/formulas/or.php">OR function</a> to allow you to test for multiple conditions. But in
this case, only one or more of the conditions within the OR function needs to
be TRUE for the condition to be met.</blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" align="left" style="border: none; margin-left: 6.75pt; margin-right: 6.75pt;">
 <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:14.05pt">
 <td width="186" valign="top" style="width: 139.85pt; border-width: 1pt; border-style: solid; border-color: black; padding: 0in 5.4pt; height: 14.05pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">Product<o:p></o:p>
 </td>
 <td width="186" valign="top" style="width: 139.85pt; border-top: 1pt solid black; border-right: 1pt solid black; border-bottom: 1pt solid black; padding: 0in 5.4pt; height: 14.05pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">Quantity<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:1;height:14.05pt">
 <td width="186" valign="top" style="width: 139.85pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt; height: 14.05pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">Apples<o:p></o:p>
 </td>
 <td width="186" valign="top" style="width: 139.85pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt; height: 14.05pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">10<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:2;height:14.05pt">
 <td width="186" valign="top" style="width: 139.85pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt; height: 14.05pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">Oranges<o:p></o:p>
 </td>
 <td width="186" valign="top" style="width: 139.85pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt; height: 14.05pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">7<o:p></o:p>
 </td>
 </tr>
 <tr style="mso-yfti-irow:3;mso-yfti-lastrow:yes;height:14.85pt">
 <td width="186" valign="top" style="width: 139.85pt; border-right: 1pt solid black; border-bottom: 1pt solid black; border-left: 1pt solid black; padding: 0in 5.4pt; height: 14.85pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">Paper<o:p></o:p>
 </td>
 <td width="186" valign="top" style="width: 139.85pt; border-bottom: 1pt solid black; border-right: 1pt solid black; padding: 0in 5.4pt; height: 14.85pt;">
 <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
 normal;mso-element:frame;mso-element-frame-hspace:9.0pt;mso-element-wrap:
 around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
 margin;mso-element-left:center;mso-element-top:9.35pt;mso-height-rule:exactly">250<o:p></o:p>
 </td>
 </tr>
</tbody></table></blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><o:p></o:p></blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><span style="font-size: 14pt; font-family: "Times New Roman", serif; color: black; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Ex:
- =IF (OR(A2="Apples",A2="Oranges"),
"Fruit", "Other")<o:p></o:p>

<span style="font-size:14.0pt;
line-height:115%;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;
color:black;mso-themecolor:text1;mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">   Result:<span style="font-size:14.0pt;line-height:115%;font-family:"Times New Roman","serif";
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;color:black;
mso-themecolor:text1;mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA"> -   "Fruit" </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><span style="font-size:14.0pt;line-height:115%;font-family:"Times New Roman","serif";
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;color:black;
mso-themecolor:text1;mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">Ex:
- =IF (OR(A4="Apples",A4="Oranges"),
"Fruit", "Other")<o:p></o:p>

Result: -   "other" </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><span style="font-size:14.0pt;line-height:115%;font-family:"Times New Roman","serif";
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;color:black;
mso-themecolor:text1;mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA"> Concatenate:
- It Combine the more cell text into one cell.<o:p></o:p>

<o:p></o:p>

Syntax: -  =concatenate
(text1,text2, text3)<o:p></o:p>

Ex: -         =concatenate (A1,B1,C1) </blockquote>

Notifications

Your order is placed

James Lemire

Your item is shipped

Salena Layfield

Add New Topic

Short Key List