MS Excel VLookup

..................search for an item of data in a table and then extract the rest of information relating to that item

................. ek table mein kisi data ki khoj karke aur phir us item se sambandhit baki jaankari nikalta hai

• vlookup ()

• if ()

• count()

• sumif()

An example of a range address

• A1;B3

• A1:B3

• A1-B3

• A1.B3

What is the Keyboard shortcut to make a cell absolute reference?

Kisi cell reference ko Absolute cell reference ( $A$2 ) bnane ke liye keyboard shortcut key select krein.

• F1

• F2

• F3

• F4

Which of these Vlookup functions is searching for an exact match?

In Vlookup functions mein se kaunsa ekdum sahi match khoj raha hai?

• =VLOOKUP (True, A2:B6, 2, C16)

• = VLOOKUP (C16, A2:B6,3, TRUE)

• =VLOOKUP (C16, A2:B6, 3, FALSE)

• =VLOOKUP (C16, A2:B6,1, $C$4:$D$15)

We want to make a Payment Type Column as a drop-down list in a cell. Which feature should we use?


Ham ek "Payment Type" column ko ek cell me drop-down list ke roop mein banana chahte hain. Hamein kaunsa feature istemal karna chahiye?

• Conditional formatting

• Data validation

• Bulleted list

• Absolute cell reference

The first argument in a VLOOKUP function tells the function.................

VLOOKUP function mein pehla argument function ko batata hai.................

• What to look for

• Where to look

• To use an approximate or exact match

• The column index number

What value would excel return for this formula? =(82-32)*5+8*2

Is formula ke liye Excel kis maan (value) ko vapas karega? =(82-32)*5+8*2

• 230

• 21

• 226

• 26

VLOOKUP formula to be used to get result in the highlighted cell

Konsa formula highlighted cell me dikh rahe data ko lane ke liye use kiya gya hai

• =VLOOKUP(A2:B9,2,FALSE)

• =VLOOKUP(D3,A2:B9,FALSE)

• =VLOOKUP(D3,A2,2,FALSE)

• =VLOOKUP(D3,A2:B9,2,FALSE)

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

Neeche diye gaye formulas me se kaun se sahi syntax (formula arguments) VLOOKUP function ke liye hai?

• =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)

• =VLOOKUP(lookup_value, table_array, col_index_num, value)

When using Formulas and Functions and using text within them, you need to write them in between " "


Jab aap Formulas aur Functions ka istemal karte hain aur unke andar text ka istemal karte hain, toh aapko unhe " " ke beech mein likhna zaruri hai.

• TRUE

• FALSE