Look-up function

[Natalie]

I have 2 sheets, sheet 1 is full record list and sheet 2
is a fax cover that will be created based on sheet 1.

How can I do the following?

Input a number on sheet 2 (eg. cell A1) so that it will
lookup a matching value from a column in sheet 1 (eg.
column A) and then a cell on sheet 2 will return a value
in another column (eg. column B) from sheet 1?

eg. I type in "1" in sheet 2 and a cell on sheet 2 will
return a name eg. "ABC", which has a ref no. "1" on sheet
1

 

[Laura Cook]

Check out the VLOOKUP function in Excel's help.

For Example:

=VLOOKUP(A1,Sheet1!A1:B10,2,0)