A B C ---------------------------------------D -----04/19/11 04/20/11 04/21/11
22 john 04/19/11 --------------------------------22 ------04/19/11 04/20/11
23 susan 04/19/11
22 john 04/20/11
24 rico 04/21/11
21 new 04/19/11
please help me how to come up with look like this.
lookup value is in column D ("22") and those dates above on the first line (beside D). table array is A1 to C1..
as we can see, entry of john is two.. what formula will i put to match on D1 and date header using A1 to C1 as table..
thanks.
22 john 04/19/11 --------------------------------22 ------04/19/11 04/20/11
23 susan 04/19/11
22 john 04/20/11
24 rico 04/21/11
21 new 04/19/11
please help me how to come up with look like this.
lookup value is in column D ("22") and those dates above on the first line (beside D). table array is A1 to C1..
as we can see, entry of john is two.. what formula will i put to match on D1 and date header using A1 to C1 as table..
thanks.
Last edited: