Hi all
could someone please give me a hand with a formula which will match the date entered in range B1:G1 across J1:S1 and then do index match within an appropriate column to find a corresponding value for ID in column A?
The shown below is a simplified version of the original file as both sets of data (B1:G1 and J1:S1) live in a separate worksheets.
The data in column J1:S1 cannot be prepared as one maser ID and multiple daily values. This must be a criteria dependant match as described above. I have spent most of the Xmas day trying to resolve this problem, providing a solution would be a fantastic Xmas gift for me.
Kind regards.
excel2411.JPG
Bookmarks