Yes. I'm guessing A controls the row & B controls the column you want to look
at.

Example:
B C
2 x y
3 z aa

My small table has row headers of 2 and 3, column headers of B and C. The
blank spot in top-left corner is cell A1. Let's say my drop down in column A
I choose "2" and in column B dropdown I choose "C". My formula is:

=INDEX('Sheet2'!$B$2:$D$3,MATCH(A2,'Sheet2'!$A$2:$ A$3,0),MATCH(B2,'Sheet2'!$B$1:$C$1,0))

The spits out the result "y".

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?