How do I match values from cells to a list of info
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. |
How do I match values from cells to a list of info
One way...
A10 = vertical lookup value = 2 B10 = horizontal lookup value = 1.5 =VLOOKUP(A10,A1:D6,MATCH(B10,A1:D1,0),0) -- Biff Microsoft Excel MVP "Bseg" wrote in message ... 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. |
All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com