Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Go To Cell Display
Within this function
=IF(VLOOKUP(MIN($C$6:$C$28),$H$5:$J$16,3)<"0","Av ailable","Not Available") I want to the place the "Available" or "Unavailable" in column 'B' next to the corresponding row that matches the findings in column 'C'. In other words how do you write a function that says 'Go To Cell xxx and display xxx' based upon the results of a function? Any thoughts? |
#2
|
|||
|
|||
Stan wrote:
Within this function =IF(VLOOKUP(MIN($C$6:$C$28),$H$5:$J$16,3)<"0","Av ailable","Not Available") I want to the place the "Available" or "Unavailable" in column 'B' next to the corresponding row that matches the findings in column 'C'. In other words how do you write a function that says 'Go To Cell xxx and display xxx' based upon the results of a function? Any thoughts? ------------------- A function can only write to the cell from which it's called. The simplest answer is to put your IF function in that column B cell where you want the answer displayed. If there's some esoteric reason that you can't do that, then you need to write a macro SUB program to do it, rather than a function. Macros can reach out and touch any cell. Good luck... Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
How do I display hyperlink in Excel cell? | Excel Discussion (Misc queries) | |||
display the value of a cell adjacent to the cell with max value | Excel Worksheet Functions | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel |