Hi,

I have imported a data text file into Sheet1 of worksheet......the
first column of which has Names.

Name ACW Talk Hold etc.......

In Sheet2, i have done data validation (List) on a A2 cell & get a
dropdown list of the Names using a defined name say "Agent".

In B2, i am trying to get their calculated AHT, the formula for which
is :

AHT = ACW + Talk + Hold

I have to do 3 Vlookups to get the result.

Is there a Better way of doing this by using Vlookup ONLY ONCE & get
the same results....OR some other way ?????


Please help!