| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel do 'lookups' and show different data depending upon the cell with the focus?
I have Excel 2008 for the Mac and (to be honest) I'm only an occasional
user. Is there a way to do the following: I have the focus on cell A1. In cell D1 Excel will display the word "Elephant" I move the focus to cell A2 and Excel will display in cell D1 the word "Giraffe". I move the focus to cell A3 and Excel will display in cell d1 the word "Zebra" In other words, can Excel do some kind of lookup based on the cell the focus is on? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show cell contents depending on other cells information | Excel Programming | |||
| How to show cell selection when excel not in focus + other questio | Setting up and Configuration of Excel | |||
| Can I show a picture depending on what data is selected in a cell | Excel Discussion (Misc queries) | |||
| Hide or show data labels depending on value? | Excel Programming | |||
| How to hide/show a textbox depending on cell value | Excel Programming | |||
Threaded Mode
