Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula? - Free Printable

- The formula in cell G2, `=VLOOKUP(B2,'SR-Data'!$A$2:$B$73,2,0)`, is designed to look up the SalesRep name in cell B2 within the range 'SR-Data'!$A$2:$B$73 and return the corresponding value from the second column of that range (the Region).
- The formula uses an exact match (`0` as the last argument), which is appropriate for looking up names.
- The range `'$A$2:$B$73'` is absolute, ensuring it doesn't change when the formula is copied down.
- The image shows the formula has been entered into G2 and then copied down to fill the rest of the column, as indicated by the "Ctrl + Down Arrow" graphic. This action populates the entire Region column with the correct region for each sales representative listed in the SalesRep column.