using VLOOKUP with 2 search columns

[Trebor777]

Hi

I am trying to pick out a value from a lookup table, using vlookup or similar. I have used vlookup before no problem.

I am searching on a date, but the date has no year associated, just a column of days (02, 09, 18, etc) and a column of months (01, 02,....31).

I could turn these into date numbers and search on that, but it would need a year number as well?

I am not sure how to proceed

Any ideas Please?

K

[JohnTopley]

Please post a small sample file (not image) showing required results.

[Glenn Kennedy]

Are there data from several years present? it would be helpful if you would attach a sample file (Go Advanced/Manage Attachments).

[Trebor777]

The file concerned has a lot of personal data in it, so I will have to modify it 1st. No problem.

I will return !!

[FDibbins]

Perhaps something like this?

	A	B	C	D	E	F
1	day	Month	data
2	1	1	10		Day	2
3	2	1	20		Month	2
4	3	1	30		Data	60
5	4	1	40
6	1	2	50
7	2	2	60
8	3	2	70
9	4	2	80
10	1	3	90
11	2	3	100
12	3	3	110
13	4	3	120

F4=INDEX($C$2:$C$13,MATCH(F2&" "&F3,INDEX($A$2:$A$13&" "&$B$2:$B$13,0),0))

[Tony Valko]

When using numbers with leading zeros, you're just asking for unnecessary complications.

[Trebor777]

Perhaps something like this?

	A	B	C	D	E	F
1	day	Month	data
2	1	1	10		Day	2
3	2	1	20		Month	2
4	3	1	30		Data	60
5	4	1	40
6	1	2	50
7	2	2	60
8	3	2	70
9	4	2	80
10	1	3	90
11	2	3	100
12	3	3	110
13	4	3	120

F4=INDEX($C$2:$C$13,MATCH(F2&" "&F3,INDEX($A$2:$A$13&" "&$B$2:$B$13,0),0))

The table you created is spot on. This looks helpful, I will try it. many thanks

[FDibbins]

Happy to help, thanks for the feedback