Thank you. I got it to work on one cell, and am playing with it now.

Ruth

Hi,

I have got this to work, except for one issue. I did find a solution to the issue, but it requires removing 3 items from the table and making a separate list and then doing a minor change to the layout so that these items would be at the bottom of where I used the vlookup, and then putting the list in the cells. And, I was wondering if this was the way to go on this. I've detailed the issue below more clearly, I hope

In that vlookup table, which is on a separate sheet, there are 9 items: mortgage, water, trash etc. in one column, and then their corresponding payees in the other, these are fixed payees for 6 of the items. However, for 3 items, as an example, improvements, there can be no corresponding fixed payees since, for example improvements might be a new stove, or having to replace, not repair a window. If I leave those items with no fixed payee in that table, when you are on the worksheet in column B and you choose Improvements from the list, it automatically fills in a 0, whereas my friend is actually going to have to type stove, or John's Window Replacement or something like that. So would it be better to do it with a separate list as I have it now and not having the Vlookup in those corresponding cells at all? Very long explanation for a maybe short answer!

Ruth