How to Use VLookup With Different Sheets on Excel | Chron.com

Excel's VLOOKUP function searches an array of cells for data you choose, returning data ... and return the tasks' statuses to a different sheet, which reports on a selection of the tasks.

smallbusiness.chron.com