multiple vlookups in one statement


D

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
 
Ad

Advertisements

C

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
 
D

Dave

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

Dave


CLR said:
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 said:
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
 
Ad

Advertisements

C

CLR

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

Vaya con Dios,
Chuck, CABGx3




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

Dave


CLR said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top