AllyJM
New member
- Joined
- Jun 9, 2015
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Location
- Ayrshire, Scotland
- Excel Version(s)
- 2003,2007
I have a list of friends and family birthdays, and I'm using an Index & Match formula to return the person's name from matching the values of two cells, i.e. Day(A1) and Month(B1). The list of day numbers is in A6:A10, and month numbers in B6:B10, and the names in C6:C10. The formula I'm using is an array formula as follows: {=INDEX(C6:C10,MATCH(A1&B1,A6:A10&B6:B10,0))}. Everything works fine except the one for Jim. His name comes up if I put 11 in cell A1 and 1 in cell B1 his name comes up, which is correct. However, if I swap them and put 1 in cell A1, and 11 in cell B1, his name still comes up, which is incorrect. Is it me or a quirk of Excel? Thanks in advance for any help.
Can't show a screenshot unfortunately. Haven't posted often enough.
Can't show a screenshot unfortunately. Haven't posted often enough.