Hi,

You need to use v-lookup for this. Check out how to use v-lookup in the
excel help content. I will explain what you need to enter into the functions
arguments below:

Lookup_value - click on cell M11 in sheet 1 (which if you explained properly
has the value 2 in it)

Table_array - this is what place in which you want to search for the "Lookup
value" (cell m11). You can either highlight the whole of sheet 2 or just the
table of information within sheet 2.

Col_index_num - This is asking you that once it has found the value from
cell m11 in sheet 2 which column do you want to return. Like you said you
don't want it to return the actual value in cell m11 (which would probably be
column A). You want the value from column B. So type in 2 into this line.

Range_lookup - finally this wants to know if it's looking for the exact
value in cell m11 or just any cell in sheet 2 with the the same numbers as
cell m11 (in other words if cell m11 has a value of 2 then the lookup can
search and return a cell in sheet 2 that has a value of 129 because it has a
2 in it). If you want the exact value (and you do) then type FALSE.

That should do it.

Carl