Computer Science, asked by Sandeep4281, 1 year ago

what is the use of vlookup function in excel ?

Answers

Answered by rajeshti2

1

Answer:

Explanation:

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_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.

Previous Question

Next Question

Similar questions

Computer Science, 6 months ago

_____ tool is handy tool used to select the areas which have complex edges...

Math, 6 months ago

15. Mamta took a loan of 30,000 from the bank to buy a motor boat. She paid back 32,400 in one year. How much did she pay back every month? * 2700 7 2000 62400 2400 12:57 PM 11 two and a half hour?

Math, 6 months ago

Q18. A floral design on a floor is made up of tiles as shown in fig. which are triangular, the sides of a triangle being 9cm, 28cm and 35cm. 28 cm c) 10 d) 18 e e How many tiles are there? (a) 8 b) 16 The area of 1 tile in cm2 (a) 3616 b)3076 c)3456 d)3376 If the cost of polishing the triangle is 1per cm2 . Then the cost of polishing one triangle is (a) 3616 b) 34V6 C) R 37 d)* 38 (iv) If the...

Chemistry, 1 year ago

The rate of certain hypothetical reaction A+B+C- product is given by r =-d(A) 1 /2 (B) 1 /3 (C) 1 /4 the order of the reaction is...

English, 1 year ago

Why did pandora open the box twice...

Physics, 1 year ago

Feeling bored.......... Is there anyone...who tell me What is Pulsar??? ❤❤❤...

Math, 1 year ago

water flows into a tank at the rate of 2.5 M per second calculate the time it would take to fill a tank with electric angular base 75 cm by 100 cm to a height of 64 C M...

French, 1 year ago

Quelle est la fête nationale de la France...