Excel: HELP! Getting the last cell in a range from a different tab

Hi all, I hope you can help. I have read these forums for a long time but just signed up as this is the first time I haven’t been able to find an answer on here! I am looking for a formulae to get the last cell in a range from a different tab. The range is B9, G9 L9 Q9, V9, AA9, AF9 on the worksheet 'New Monitoring'. I need to show the last used cell from this range in a cell on a different tab/worksheet. I have tried to name the range as 'TestRange' and have tried this formulae - INDEX(TestRange,MATCH(9.99999999999999E+307,TestRange)) But it doesn’t return the value. I am scratching my head and have hit a brick wall. Any help would be hugely appreciated.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 06, 2014.

For more resources for Microsoft Excel