multiple vlookups in one statement
 

I need to look at two columns using vlookup and with the lookup values pull
in the person assgned to the task from a second file.

On the data file, my lookup value is column M then column H using the first
character. I use the criteria to match on my assignment file with a match on
column M and a range on column H. The formula I created is below but does not
work. Any suggestions?

example
Col M(work q name) Col H(Account Begin Range) Col I(Account End Range)
abc A F
abc G S
abc T Z

= VLOOKUP((Left(H2,1,1)), (VLOOKUP(M2,'Location of
file\[Specialist-Supervisor Assignments.xls]SSAssign'! !$A$2:$H$446, 6,
FALSE))!SSAssign, 6, TRUE

--
Thank you

Dave

multiple vlookups in one statement
 

The easiest way I know to use two columns in a VLOOKUP is to CONCATENATE them
into a helper column set to the left of the LookupTable........then use
something like

=Vlookup(m2 & LEFT(H2,1), YourTable,7,false)

Vaya con Dios,
Chuck, CABGx3



"Dave" wrote:

I need to look at two columns using vlookup and with the lookup values pull
in the person assgned to the task from a second file.

On the data file, my lookup value is column M then column H using the first
character. I use the criteria to match on my assignment file with a match on
column M and a range on column H. The formula I created is below but does not
work. Any suggestions?

example
Col M(work q name) Col H(Account Begin Range) Col I(Account End Range)
abc A F
abc G S
abc T Z

= VLOOKUP((Left(H2,1,1)), (VLOOKUP(M2,'Location of
file\[Specialist-Supervisor Assignments.xls]SSAssign'! !$A$2:$H$446, 6,
FALSE))!SSAssign, 6, TRUE

--
Thank you

Dave

multiple vlookups in one statement
 

thanks for your response. This is the route I was going to take because it
simplifies the process.
--
Thank you

Dave


"CLR" wrote:

The easiest way I know to use two columns in a VLOOKUP is to CONCATENATE them
into a helper column set to the left of the LookupTable........then use
something like

=Vlookup(m2 & LEFT(H2,1), YourTable,7,false)

Vaya con Dios,
Chuck, CABGx3



"Dave" wrote:

I need to look at two columns using vlookup and with the lookup values pull
in the person assgned to the task from a second file.

On the data file, my lookup value is column M then column H using the first
character. I use the criteria to match on my assignment file with a match on
column M and a range on column H. The formula I created is below but does not
work. Any suggestions?

example
Col M(work q name) Col H(Account Begin Range) Col I(Account End Range)
abc A F
abc G S
abc T Z

= VLOOKUP((Left(H2,1,1)), (VLOOKUP(M2,'Location of
file\[Specialist-Supervisor Assignments.xls]SSAssign'! !$A$2:$H$446, 6,
FALSE))!SSAssign, 6, TRUE

--
Thank you

Dave

multiple vlookups in one statement
 

You're welcome, and thanks for the feedback............

Vaya con Dios,
Chuck, CABGx3




"Dave" wrote:

thanks for your response. This is the route I was going to take because it
simplifies the process.
--
Thank you

Dave


"CLR" wrote:

The easiest way I know to use two columns in a VLOOKUP is to CONCATENATE them
into a helper column set to the left of the LookupTable........then use
something like

=Vlookup(m2 & LEFT(H2,1), YourTable,7,false)

Vaya con Dios,
Chuck, CABGx3



"Dave" wrote:

I need to look at two columns using vlookup and with the lookup values pull
in the person assgned to the task from a second file.

On the data file, my lookup value is column M then column H using the first
character. I use the criteria to match on my assignment file with a match on
column M and a range on column H. The formula I created is below but does not
work. Any suggestions?

example
Col M(work q name) Col H(Account Begin Range) Col I(Account End Range)
abc A F
abc G S
abc T Z

= VLOOKUP((Left(H2,1,1)), (VLOOKUP(M2,'Location of
file\[Specialist-Supervisor Assignments.xls]SSAssign'! !$A$2:$H$446, 6,
FALSE))!SSAssign, 6, TRUE

--
Thank you

Dave