Automatic formula instead of a temp formula

try this in b2 fill down and right

Formula:

Please Login or Register  to view this content.

if the 0 showing is a real problem you can

do conditional format to make 0 = blank
or
do an IF statement to remove the 0
or
make a special number format to make 0 = blank

i went with conditional format in the attached example because its the easiest to setup

in that case i would use a different formula

Using CSE formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Formula:

Please Login or Register  to view this content.

Thanks for the rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

errrm it looks off
your index needs to be what you want to return in the formula? however you refer to it as being date match of am19?
A2 and B1 needs to be replaced with your header down and across

suggest you post example again or go back to the previous file and break down the formula to see exactly what needs to replace what

taking the iferror out
INDEX(data!$S$4:$S$13,MATCH(B$1&$A2,data!$F$4:$F$13&data!$I$4:$I$13,0)

Data s4:s13 = data sheet - Data Column = what you want to return from the formula
B1 & A2 = data down the left and header across the top
Data F4:f13 = Data sheet Column 1 & Data i4:i13 = Data sheet Column 2

note the & locations to be coincide together
B1 = Data Column F
A2 = Data Column I