Using Excel VLOOKUP function across two sheets

Question

I have two sheets in an Excel workbook and want to use the VLOOKUP() function to search a table in Sheet2 and return the result to Sheet1. How might I do this?

The data looks like this:

Sheet1

   A     B     
1  id   name   
2  111  Jacob
3  102  david
4  110  John

Sheet2

   A     B
1  id   Cell   
2  111  03563334879
3  102  03563331234
4  110  03563334222

Answer 1

The syntax for VLOOKUP is

VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup)

OR, to start in a cell C2 type:

• =VLOOKUP(
• Then click cell A2 (The value to lookup for this row)
• Then type a comma
• Then excel allows you to click on another sheet to select the table from sheet2, so this would be range Sheet2!A2:B4
• comma
• You want to return the second row from your lookup array so type 2
• comma
• You want an exact match so type FALSE
• close brackets and hit enter

This succeeds for cell C2, but if you drag it down using the cell's lower-right corner, it will fail in consecutive rows since the table array references are relative and will be moved one down for each cell you move. Click on each of them (A2 and B4) and press F4 to make the lookup table array fixed (that's not the right word), or just add the "$" as seen below. This corrects the row and column references so that they won't be altered by copying down.