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

[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.

 

[T. Valko]

One way...

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

=VLOOKUP(A10,A16,MATCH(B10,A11,0),0)