Computer Science, asked by Mehaksohi4770, 1 year ago

How to select the value of cell using adjacent cells in excel?

Answers

Answered by alualualaualau233

. Select a blank cell (here I selectcell C3), copy and paste the formula =VLOOKUP(MAX(A2:A11), A2:B11, 2, FALSE) into the Formula Bar, and then press the Enter key. See screenshot: Then the adjacent cell value of the largest weight in column A is populated in the selected cell.

Previous Question

Next Question

Similar questions

Political Science, 7 months ago

Answer it fast its emargancy....

Accountancy, 7 months ago

find the LCM of 2 and 10...

Physics, 7 months ago

Describe an experiment to find the specific heat of a solid by the method of mixtures.

Computer Science, 1 year ago

How to select a specific record from database using where condition?

Math, 1 year ago

concrete mix is being used to lay tiles in a rectangular plot of length 45 M and width 20 m exactly the same amount of concrete is required to live floor tiles in a square but what is the length of the side of square plot...

Math, 1 year ago

check the weather 6 ,8, 10 forms pythagorean triples are not...

Math, 1 year ago

Can 2 numbers have 18 as their hcf and 380 as their lcm justify...

English, 1 year ago

Find the largest number wch divides 224, 250 and 302 and leaves remainder 3 in each case.