L

#### laandmc

I have two columns which I input data into, these correspond to the title

row in a matrix. I want to find a formula rather like Vlookup but for a

matrix which looks for the row and the column in one go. At the moment I am

getting round it by using a lengthy If function but I would really like to

get it into one formula.

See below example

A B C

1 Name Date

2 a Adam Nov <-- rows A & C are inputted, row B has the formula

3 b Bob Nov Which looks up the values from the lookup table

4 a Andrew Dec below.

5 b Barry Dec

6

7

8 Lookup Table

9 Nov Dec

10 a Adam Andrew

11 b Bob Barry

If any one could help i'd be very grateful.

Cheers