Sorry for the empty post,

I have data in 3 columns where I would find the data depending on the first
two columns
e.g.
firstname (column A), lastname (B) to find adress (C)

--
Shared knowledge makes you smarter


"Roger Govier" wrote:

Hi

Not much to go on here. It is lays better to post details of your actual
question in the body of the post.

As a generalisation.
If in cells B1:M1 you had Jan, Feb ..... Dec
If in cells A2:A32 you had the numbers 1 through 31

In cell O1 you Had Jun and in cell O2 you had 5
then
=INDEX($A$1:$M$32,MATCH(O2,$A$1:$A$32,0),MATCH(O1, $B$1:$M$1,0))
would return the value that is in the cell for Jun 5th.

INDEX require 2 inputs, Row and Column.
The first MATCH finds the row number, the second MATCH finds the column
number.

--
Regards

Roger Govier


"Excel ESG" wrote in message
...

--
Shared knowledge makes you smarter