multiple vlookups in one statement

[Dave]

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

 

[CLR]

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]

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

Dave

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

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

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

Dave

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

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