| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to conditionally reference a cell
I had this done once before and now I don't remember how I did it. It took me
a long time to find the answer the first time and now I can't seem to remember it or find it again at all. I have Sheet1 that has data in it. On Sheet2 I want some of the information from a single row in Sheet1 to fill in certain cells. If I want the information from row 5 of Sheet1, I will type 5 in Sheet2!A1. So now I want the information from Sheet1!F5 in Sheet2 B1. So what is the correct cell reference for Sheet2 B1? There is some way to do the Col as Sheet1!F and the row as (A1). Any help is greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally format only some of the text in a cell? | Excel Worksheet Functions | |||
| Conditionally lock a Cell | Excel Worksheet Functions | |||
| Lock cell control conditionally? | Excel Discussion (Misc queries) | |||
| How can you lock cell conditionally | Excel Discussion (Misc queries) | |||
| Conditionally format one cell for contents of another? | Excel Worksheet Functions | |||
Threaded Mode
