Hi, ortizmo. I'm trying to get a bigger-picture idea of what's going on. A few questions:

1) You're trying to find the minimum price, I take it?

2) What's the significance of rows 5 and 21? Are the four tables all on the same worksheet, I'm guessing?

3) Isn't it possible that ~more~ than one table will have a part not available? Seems to me you're trying to make sure your formula works even when one value isn't available, but not considering that there may be more.

4) What is the value in the price column when the Unavailable box is checked? Does it stay the same as before?

5) There may a formula that'll work for this, but it seems complex enough that it may pay you to write your own worksheet function. And you did, after all, post this question in the VBA ~programming~ forum, so I suppose you've considered that option, even though you don't mention it?