Vlookup

[TheTone]

Hi

I've been told that this can be done using this fuctions. I want to be able to type a name in says A1 and in A2 it returnes the managers name. Then say another name in B2 and in B2 it returnes the manager name.

Any help will be welcomed.

Thanks

[Pete]

You will first need to set up a table containing 2 columns - the first
column should list all the names and the second column should list the
manager's name against each employee(?). Assume this table is from L1
to M20. In cell A2 you should enter the formula:

=VLOOKUP(A1,$L$1:$M$20,2,0)

and this can be copied into B2. Now when you type a name into A1 the
manager's name will appear in A2, similarly with a name in B1.

Hope this helps.

Pete

[Govind]

Hi,

You should already have a list of names and associated manager names in
another range for this. For eg, if you have this matrix in range A1 to
B10 and you type in the employee's name in cell C1, use this formula in D1

=VLOOKUP(C1,$A$1:$B$10,2,FALSE)

Regards

Govind.

TheTone wrote:

> Hi
>
> I've been told that this can be done using this fuctions. I want to be
> able to type a name in says A1 and in A2 it returnes the managers name.
> Then say another name in B2 and in B2 it returnes the manager name.
>
> Any help will be welcomed.
>
> Thanks
>
>

[Ltat42a]

Hi

I've been told that this can be done using this fuctions. I want to be able to type a name in says A1 and in A2 it returnes the managers name. Then say another name in B2 and in B2 it returnes the manager name.

Any help will be welcomed.

Thanks

To expand on this a lil. Can vlookup be used with dates?
Example...I have a column of dates, names, and numeric values.
Can it return all of the values for Jan? then Feb?, then Mar?
etc....all the way to Dec??

Thanx

[Pete]

VLOOKUP enables you to scan through one column of a table looking for a
match with a particular value and can then return the other values in
the matching row from the table. So, for example, imagine you have this
table in cells E1 to H7:

code1 text1 value1 date1
code2 text2 value2 date2
code3 text3 value3 date3
code4 text4 value4 date4
code5 text5 value5 date5
code6 text6 value6 date6
code7 text7 value7 date7

Elsewhere in the sheet (say in column A) you have some values such as
"code5", "code2" etc. In the next column B you can enter the formula:

=VLOOKUP(A1,$E$1:$H$7,2,0)

and this will return "text5" and "text2" when copied down.

So, the first parameter is the cell you want to find a match on, the
second parameter is the range specifying where the table is located,
the third parameter specifies which column of the table you want to get
data from, and the final parameter (either 1 or 0, or TRUE or FALSE) is
used to indicate if the table is sorted and if you want an exact match.

Dates, numbers and text values can all be used within the table, as
appropriate.

Hope this helps,

Pete