COLUMN LOOKUP.

%3CLINGO-SUB%20id%3D%22lingo-sub-1506732%22%20slang%3D%22en-US%22%3ECOLUMN%20LOOKUP.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506732%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20if%20anyone%20can%20help%20%2C%20I%20want%20to%20find%20the%20last%20number%20in%20a%20column.%20Sometimes%20the%20last%20cell%20is%20blank%20and%20when%20that%20happens%20I%20would%20want%20that%20last%20blank%20cell%20to%20be%20a%20zero.%20Maybe%20some%20kind%20of%20IFERROR%20formula%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1506732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1507281%22%20slang%3D%22en-US%22%3ERe%3A%20COLUMN%20LOOKUP.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507281%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706837%22%20target%3D%22_blank%22%3E%40lorigraf_LORIl60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDepends%20what%20do%20you%20mean%20under%20the%20column%2C%20if%20some%20range%20that%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDEX(A1%3AA80%2CAGGREGATE(14%2C6%2C1%2F(ISNUMBER(A1%3AA80)%2BISBLANK(A1%3AA80))*ROW(A1%3AA80)%2C1))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1507547%22%20slang%3D%22en-US%22%3ERe%3A%20COLUMN%20LOOKUP.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507547%22%20slang%3D%22en-US%22%3EAnother%20possibility%2C%20I%20think%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DLOOKUP(MAX(A1%3AA10)%2B1%2C--(A1%3AA10))%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

So if anyone can help , I want to find the last number in a column. Sometimes the last cell is blank and when that happens I would want that last blank cell to be a zero. Maybe some kind of IFERROR formula? 

2 Replies
Highlighted

@lorigraf_LORIl60 

Depends what do you mean under the column, if some range that could be like

=INDEX(A1:A80,AGGREGATE(14,6,1/(ISNUMBER(A1:A80)+ISBLANK(A1:A80))*ROW(A1:A80),1))
Highlighted
Another possibility, I think:

=LOOKUP(MAX(A1:A10)+1,--(A1:A10))