| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If yes then display information in cell
I need a little help figuring out how i can display a cell (I28) if cell
(G28) is yes. The current formula that is working for me now is =IF(G28="Yes",I28,"No Information to Display"). Now the problem i am having is there is a range of cells (G28:G500) that could return a yes value but there will be only one yes at a time in the G column and for that yes row i would like to display that "I" cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If yes then display information in cell
If I understand correctly
index(I28:I500,match("yes",G28:G500,0),1) -- caroline "Frustrated" wrote: I need a little help figuring out how i can display a cell (I28) if cell (G28) is yes. The current formula that is working for me now is =IF(G28="Yes",I28,"No Information to Display"). Now the problem i am having is there is a range of cells (G28:G500) that could return a yes value but there will be only one yes at a time in the G column and for that yes row i would like to display that "I" cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If yes then display information in cell
That worked great, thank you.
"caroline" wrote: If I understand correctly index(I28:I500,match("yes",G28:G500,0),1) -- caroline "Frustrated" wrote: I need a little help figuring out how i can display a cell (I28) if cell (G28) is yes. The current formula that is working for me now is =IF(G28="Yes",I28,"No Information to Display"). Now the problem i am having is there is a range of cells (G28:G500) that could return a yes value but there will be only one yes at a time in the G column and for that yes row i would like to display that "I" cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display information from other worksheet | Excel Worksheet Functions | |||
| Display last status information | Excel Worksheet Functions | |||
| HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS | Excel Worksheet Functions | |||
| How do I export information from FileMaker and still display zero. | Excel Discussion (Misc queries) | |||
| Display references to linked information | Excel Worksheet Functions | |||
Linear Mode
