Excel Forum



Excel Magic Trick 417: Get Last Value from Multiple Sheets


See how to get the last value in Column B from across many sheets using the LOOKUP and INDIRECT functions. This is from a post at the Mr Excel Message Board.





Got a Question? Ask it Here in the Forum.