If I may, I have what I hope will be just one last question. The array

formulas are working great, although I have one small hitch. There are

three different tables I'm drawing data from, and roughly 20 cells in total

I need to populate. For clarity, the columns are arranged so that the

different tables are not in consecutive sequence. For instance, I have

something like this:

A | B | C | D | E | F |

User Defined | Pull from Table1 | Pull from Table2 | Pull from Table1 | Pull from Table3 | Pull From Table2 |

I'd like to set up three different array formulas and have each one pull the

needed data. However, I don't seem to be having much luck selecting

different cells (holding the CTRL key to select multiple) and assigning an

array. It doesn't seem to recognize each cell I've selected. If the cells

are consecutive I don't have any problem. I could possibly rearrange the

cells so that tables 1, 2, and 3 are next to each other. My only hesitation

is that the spreadsheet contains things that happen in a sequence so it

might be a little more confusing for people to interpret.

I'll keep poking around, but thought I'd see if you knew of a method for

getting around this. I believe this is an Excel thing so I'll keep reading

up on how to select non-adjacent cells and make them part of an array

formula.

This is an Excel limitation you run into. Array formulas can only given on a contiguous block of cells.