How do I match values from cells to a list of info

  • Thread starter Thread starter Bseg
  • Start date Start date
B

Bseg

Which function would I use to link data entered in to cells to the
corresponding value in the chart.

A B C D
1 1 1.5 2
2 .5 2 7 12
3 1 3 8 13
4 1.5 4 9 14
5 2 5 10 15
6 2.5 6 11 16

According to the chart 2x1.5=10. If one cell has the value of 2 another cell
has the value of 1.5, is there a function to connect the info?

Sorry if the question makes no sense, I am struggling. Any help would be
greatly appreciated.
 
One way...

A10 = vertical lookup value = 2
B10 = horizontal lookup value = 1.5

=VLOOKUP(A10,A1:D6,MATCH(B10,A1:D1,0),0)
 
Back
Top