Show value as height while referencing weight for calc

Rtkinnell

New Member
Joined
May 29, 2019
Messages
11
I have two columns one with heights (i.e. 6'6", 6'7" etc) and one with weights say column I and J. In another cell C2 I would like to be able to enter a height, while still displaying height, yet for a calculation use the corresponding weight.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

DSCfromCFA

Board Regular
Joined
Feb 27, 2018
Messages
141
Office Version
365
Platform
Windows
G'day R,

Vlookup is the answer - providing the list of heights is in ascending order, and has no duplicates - otherwise you will need to use some other unique identifier, or method.

Your calculation will use the height from C2 (if height is used in the calculation) and where in the calculation you would use the weight, there you use Vlookup to scan down Column I until it found an exact match to C2 then grab the value from that row in Column J

Cheers

shane
 

DSCfromCFA

Board Regular
Joined
Feb 27, 2018
Messages
141
Office Version
365
Platform
Windows
You're welcome, and thanks for letting me know.
 

Watch MrExcel Video

Forum statistics

Threads
1,098,855
Messages
5,465,090
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top