M

#### Mike C

spreadsheet. Typically, I use the index and match function to do so.

However, in this case, I am trying to do a lookup based on a value

above (i.e., horizontal) and a value to the right (i.e., vertical) of

the cell in which the formula will be placed. Additionally, the sheet

from which I am pulling is similarly laid out.

To Provide an example.

Lookup Table

Months (horizontal) Jan Feb Mar Apr Etc

Names(vertical)

Jeff

Eric 5

Steve 8

John 4

Table with formula

Months (horizontal) Jan Feb Mar Apr Etc

Names

Steve

Jeff

Dave

Eric

So the question is, what formula can I use in the "Table with formula"

to pull in the numbers from the Lookup Table?

Thanks very much for any suggestions!