| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell values
if you dont have too many values
if(A1=5,a5,if(a1=4,a4,if(a1=3,a3,""))) -- paul remove nospam for email addy! "Frazer" wrote: Didnt quite know how to define what i wanted to ask in the title but ill explain more clearly here.... I have used a function that will return a certain value in a cell, for example it may return the value '5'. In this case, i then want the next cell to return the value of cell A5. If the value is 4, i want it to retrun the value of A4, if it is 3, return the value of A3, etc. Can anyone help me with how to do this?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| Multiple Cell Values, please help | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Threaded Mode
