how do I do this?

[jeh]

Hi Everyone!

Sheet1

Jan Feb March
1 1 54 54
2 34 65 98
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

this set is named date_test. I hope to be able and put a date (within this range) and find the value. This will all take place on sheet2. Please help get started.

I think that I will need formulas to break down the month and day.

Thanks very much for your time,

Jim

 

[PaddyD]

Jim,

94 posts & you still haven't downloaded the html maker - shame on you!

Does the following help:

Book4.xls
	A	B	C	D	E	F	G	H	I	J	K
1		Jan	Feb	Mar	Apr	May	Jun			Month	Day
2	1	95	49	38	67	35	92		FindWhat	Mar	6
3	2	76	100	70	84	5	17		Result	7
4	3	7	52	67	9	42	73
5	4	22	38	31	74	76	96
6	5	91	79	15	79	16	79
7	6	53	59	7	24	54	17
8	7	1	43	29	98	98	68
9	8	82	24	83	47	68	5
10	9	90	37	23	59	70	96
11
12
Sheet1

It uses match to determine which row & column we need, and index to return the result.

Paddy

 

[jeh]

Thanks PaddyD-youre right, I am ashamed.
But I'm very grateful too!

Thanks very much.

Jim