Horizontal and Vertical lookup.

**rlsublime** · 09-05-2012, 05:36 PM

I am trying to figure out how to fill in the second table with the numbers in the first table only if the vertical and horizontal date headings match. If they do not match then either leave blank or add zero. I think this is somewhat like a vertical and horizontal combination lookup. Any thoughts on how to solve this. Thanks.

**Spencer101** · 09-05-2012, 05:47 PM

I presume the first table was created by a pivot table?
If so, the second one should be easy enough to populate directly from the raw data using formulas.

To show you how, I'd need to see the raw data.

**CRIMEDOG** · 09-05-2012, 05:54 PM

Please Login or Register  to view this content.

Add this in the D18 Cell then copy into the Cells with # in their header. (where $B18 is the date to the left & D16 is the date at the top)

**Special-K** · 09-05-2012, 05:54 PM

in D18
=IF(ISNA(INDEX($C$2:$N$11,MATCH($B18,$B$2:$B$11,0),MATCH(D$16,$C$1:$M$1,0))),"",INDEX($C$2:$N$11,MATCH($B18,$B$2:$B$11,0),MATCH(D$16,$C$1:$M$1,0)))

copy down and across to AC30