Results 1 to 4 of 4

Thread: Show value as height while referencing weight for calc
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Show value as height while referencing weight for calc

    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.

  2. #2
    Board Regular
    Join Date
    Feb 2018
    Location
    Oz
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Show value as height while referencing weight for calc

    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
    Be warned - I'm an Excel enthusiast, not an expert.

  3. #3
    New Member
    Join Date
    May 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show value as height while referencing weight for calc

    Thank you for your response. That did the job

  4. #4
    Board Regular
    Join Date
    Feb 2018
    Location
    Oz
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Show value as height while referencing weight for calc

    You're welcome, and thanks for letting me know.
    Be warned - I'm an Excel enthusiast, not an expert.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •