Hi,

You could try using the =OFFSET function. For this to work you will need the
cell address for the first cell. You may be able to get this with the
=MATCH, =ADDRESS and = INDIRECT functions.

This way may possibly be of some value if you have huge amounts of data and
the three lookups are taking too long.

Hope this helps.

Sean



"junoon" wrote in message
oups.com...
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!