CODEWITHSUNDEEP
excelchartsformattingconditional-statements
Gen
Gen

Reputation: 27

Conditional formatting in excel, find variable in chart

Hi I need some help with conditional formatting in excel. enter image description here

What I want is: When I put the height of any certain individual in the "Height box" I want excel to match it to the table to the left and find the preferable weight accordingly and put the weight in the box "Preferable weight".

Upvotes: 0

Views: 41

Answers (1)

Takarii
Takarii

Reputation: 1648

VLOOKUP() is what you are after here.

Based on your example (assuming top left col is A) put into the cell next to the preferable weight label:

=VLOOKUP(WeightCell,$A$2:$B$12,2,0)

where HeightCell is the cell with the value you want to look for, and the $A$2:$B$12 part is the range of heights and weights (modify the range to suit your needs)

Upvotes: 1

Related Questions