| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What's in the adjacent cell?
A1 thru L1 has: Red, Blue, Yellow, White, Black, Gold, Brown, Grey, Purple,
Green, Pink, Orange I want to be able to type "White" (or any color) in F4 and have F5 display the value of the next column in the same row where white is, in this case "Black". What formula would I need to put in F5? Thank you, Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
| How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
| Set cell to record date when adjacent cell is filled AND NOT RESET | Excel Worksheet Functions | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
Threaded Mode
