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

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

T. Valko

One way...

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting assistance 7
Finding the proper style field and the numbered paragraph value within the style 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Grow/Shrink Text gradually from slide to slide 0
Scales on Charts. 2
Arriving at totals 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Average problem 1

Top