Search, find & display [Solved/Closed]
Hello,
I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No's listed against as reference.
I thought it would be easy enough.
Find this date e.g. "sheet 2 B3",
WK # DATE
1 31/12/2015
? 4/01/2016
2 6/01/2016
2 8/01/2016
3 11/01/2016
3 12/01/2016
Search "sheet 1 B2:H6", and return week no reference from A2:A6.
Week No. Start Date
1 27 Dec 15 28 Dec 15 29 Dec 15 30 Dec 15 31 Dec 15 01 Jan 16 02 Jan 16
2 03 Jan 16 04 Jan 16 05 Jan 16 06 Jan 16 07 Jan 16 08 Jan 16 09 Jan 16
3 10 Jan 16 11 Jan 16 12 Jan 16 13 Jan 16 14 Jan 16 15 Jan 16 16 Jan 16
4 17 Jan 16 18 Jan 16 19 Jan 16 20 Jan 16 21 Jan 16 22 Jan 16 23 Jan 16
5 24 Jan 16 25 Jan 16 26 Jan 16 27 Jan 16 28 Jan 16 29 Jan 16 30 Jan 16
I have tried SEARCH, and MATCH functions without success. At this rate it would be easier to manually imput.
Surely someone on here can help me please :)