Excel Forum
Similar Content
Vlookup Across Multiple Workbooks
Tutorial: How to use the VLOOKUP function across multiple workbooks in Excel. This will create a lin...
Vlookup Macro to Return All Matching Results from a Sheet in Excel
Macro: This Excel Macro works like a better Vlookup function because it returns ALL of the matchi...
Get Day Name from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...

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.