Display Values

[Muppet]

Hi,

I have 2 worksheets in one excel document.

- Sheet 1 has 2 columns;
column 1 is a list of values
column 2 is a list of names, each which needs to correspond with th
number next to it in column 1.

Sheet 2 has 2 columns.
In column 1 on sheet 2 I want to type any of the values in the range o
column 1 on sheet 1 and I want the name which corresponds to that numbe
to appear in column 2 on sheet 2.

However, I can't get my head around the exact formula needed to d
this. Any help would be much appreciated.

Thanks,

 

[Ryan Poth]

Muppet,

If your data is in Sheet1, columns A:B, and your value you type in is in
Sheet2, cell A1, then in cell A2 use the following formula:

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

You may then copy this formula down as far as you need it to look up
multiple values

HTH,
Ryan