Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IMPOSSIBLE?
It might be asking a lot but heres the plan:
I want my cell to tell me 2 things (part name and number). When i click on a cell containing a part number is it possible for another cell to display its name. My first thought was whether you can make a cell display the contents of the highlighted cell's 'Name Box'. |
#2
|
|||
|
|||
Maybe you could have an adjacent cell tell you the name all the time.
Debra Dalgleish has some nice instructions at: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html for using =vlookup() and =index(match()) AdrianCl wrote: It might be asking a lot but heres the plan: I want my cell to tell me 2 things (part name and number). When i click on a cell containing a part number is it possible for another cell to display its name. My first thought was whether you can make a cell display the contents of the highlighted cell's 'Name Box'. -- Dave Peterson |
#3
|
|||
|
|||
Depends on how comfortable you are in VBA. To produce a result just by
selecting a cell, you would have to write a Worksheet_SelectionChange event. If you haven't a clue what I just said, consider modifying your plan slightly. In a cell (A1 for concreteness) type the part number (or type = and then select a cell conatining the part number, so that the part number appears in A1). In another cell (say B1) you could then have a VLOOKUP formula that would return the part name corresponding to the number in A1. Jerry AdrianCl wrote: It might be asking a lot but heres the plan: I want my cell to tell me 2 things (part name and number). When i click on a cell containing a part number is it possible for another cell to display its name. My first thought was whether you can make a cell display the contents of the highlighted cell's 'Name Box'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Impossible Formula! | Excel Worksheet Functions | |||
Impossible Formula! | Excel Worksheet Functions | |||
Impossible Formula! | Excel Worksheet Functions | |||
Impossible Formula! | Excel Worksheet Functions | |||
Impossible Formula! | Excel Worksheet Functions |