On Tue, 26 Jan 2010 11:55:03 -0800, Marilyn
wrote:

First, I'm sorry but consider me a very basic user. I'm trying to figure out
how to do a formula.

Column A Column B
Column C
(has multiple options via dropdown) (has multiple options via dropdown) ??

A user selects an option in A and an option in B. In another sheet (same
workbook) I have a table of data on 5 columns/6 rows. Depending on their
selections in A & B, I need to have column C populated with data from a
particular cell in that table. Is this even possible?


If your "Column A" choosen value ends up in cell A1 and you "Column B"
choosen value ends up in cell B1, and the table of data in the other
sheet, which has the name Sheet2, has the A and B options as "axises"
in the table, like this

empty Bopt1 Bopt2 Bopt3 Bopt4 Bopt5
Aopt1 a b c d e
Aopt2 f g h i j
Aopt3 and so on
Aopt4
Aopt5
Aopt6

and you want the value h returned if the Column A choosen option is
Aopt2 and the Column B choosen option is Bopt3, then try the following
formula in the cell in Column C where you want the result to appear:

=INDEX(Sheet2!B2:F7,MATCH(A1,Sheet2!A2:A7,0),MATCH (B1,Sheet2!B1:F1,0))

Hope this helps / Lars-Åke