How to add rows in spreadsheet that is using HLOOKUP function - I.

K

kmcdowell_11

I have a spreadsheet that is currently using the following formula:
=IF(G11>0,HLOOKUP(EOMONTH(G11,0),$Y$5:$CH$6,2,FALSE),"-")

On this file I need to add some additional rows below the one referenced
above, however, I receive the following error #NAME? as soon as I insert a
row.

Before I insert the row the formula is correctly calculating. How can I fix
this error when the formula is correct? Does anyone have any ideas?

Thanks you!
 
Top