Page 261 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

1 AND: It is denoted by an asterisk(*) symbol. It returns true if and only if all conditions are true,
2 OR: It is denoted by a plus(+) symbol. It returns true if any of the statement is true.

These operators are more useful when you have the same variable with a different value. For example, let’s
consider a case, where data of 3 sellers of different months are given and you have to how much Shyam sold
potatoes.

Using-and-operator

Lookup formulasVlookup, Lookup, Index, Hlookup

Before we dive into the arcane twists of Excel Lookup formulas, let’s define the key terms to ensure that we are
always on the same page.

Lookup - searching for a specified value in a table of data.
Lookup value - a value to search for.
Return value (matching value or match) - a value at the same position as the lookup value but in another column
or row (depending on whether you do vertical or horizontal lookup).
Lookup table. In computer science, a lookup table is an array of data, which is generally used to map input values
to output values. In terms of this tutorial, an Excel lookup table is nothing else but a range of cells where you
search for a lookup value.
Main table (master table) - a table into which you pull matching values.
Your lookup table and main table may have different structure and size, however they should always contain at
least one common unique identifier, i.e. a column or row that holds identical data, depending on whether you want
to perform a vertical or horizontal lookup.
The following screenshot shows a sample lookup table that will be used in many of the below examples.

248

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77