Computer Science, asked by Mehaksohi4770, 1 year ago

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

Answers

Answered by alualualaualau233

0

. 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

Math, 6 months ago

$3x {}^{2} + 8x - 10 \: \: find \: \: the \: \: value$ ...

English, 6 months ago

WHAT ARE THE EXAMPLES OF FORESHADOWING(IT IS A POETIC DEVICE)...

Computer Science, 6 months ago

The free space list of block is...

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.