Go To Cell Display

[Guest]

Within this function
=IF(VLOOKUP(MIN($C$6:$C$28),$H$5:$J$16,3)<>"0","Available","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?

 

[Bill Martin]

Within this function
=IF(VLOOKUP(MIN($C$6:$C$28),$H$5:$J$16,3)<>"0","Available","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