| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using match but data needs to be split.
I have a table - Y axis contains whole numbers (1 - 20) and X axis contains
decimals (0.1 - 0.9). For each there is a corresponding reference that I want to be able to look up. For example, if I type 10.5, I want to be able to look up the value held at 10 on the X axis and 0.5 on the Y axis. I've tried using the index and match functions, but it doesn't work. I then looked at using RIGHT and LEFT functions to break the components down which also did not work. If anyone can help it would be much appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split cell data? | Excel Worksheet Functions | |||
| Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
| split data | Excel Discussion (Misc queries) | |||
| how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
