| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATCH | Excel Worksheet Functions | |||
| Adding up cell values only with identical info in other cells | Excel Worksheet Functions | |||
| Match values and create a list in one cell | Excel Discussion (Misc queries) | |||
| How can I match up values from 2 sheets and info in adjoining cell | Excel Discussion (Misc queries) | |||
| Prefill cust info from drop list into other cells | Excel Worksheet Functions | |||
Linear Mode
