Excel Version 2003
I've workbook containing two sheets, Input, and Output.
Output sheet - Based on combination of criteria in INPUT cell in Cells A2, B2, and C2, Range in A5:G10 should be filled taking data from Sheet!Input
Sheet Input, has 6 set of data (rowwise) for each combination of [A2+B2+C2] sorted on column O (datewise) in Sheet!Input
Currently, I've manually linked the data to illustrate, how the output should look like. If we change the combination in cells [A2+B2+C2] , output range A5:G10 should change accordingly.
How to make use of Vlookup,Index,Match, Offset function to get the desired output.
Sample file is attached for easy reference.
Thanks
Bookmarks