Need help with vlookup nested function
 

Hello,

I need help with creating a vlookup nested function using the following logic:

IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE)
OR
IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE)

Any help would be much appreciated!

Thanks,
Jaret

Need help with vlookup nested function
 

You could try this approach:

=IF(A2=R1,VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE),IF(A2=R2,VLOOKUP (B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE),"neither"))

Will return "neither" if A2 is not equal to R1 or R2. No further error
checking, so you will get #N/A if the item in B3 is not found in the table.

Hope this helps.

Pete

"mcmilja" wrote in message
...
Hello,

I need help with creating a vlookup nested function using the following
logic:

IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE)
OR
IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE)

Any help would be much appreciated!

Thanks,
Jaret

Need help with vlookup nested function
 

modify this to suit
=VLOOKUP(C2,INDIRECT("sheet" & IF(C3=B2,1,2) &"!a9:b11"),2,FALSE)

=VLOOKUP(b3,INDIRECT("'[mtn_ipbh_m40e_capacity_tool.xls]ero" & IF(a2=r1,1,2)
&"!p3:q5001"),2,FALSE)

Don Guillett
Microsoft MVP Excel
SalesAid Software

"mcmilja" wrote in message
...
Hello,

I need help with creating a vlookup nested function using the following
logic:

IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE)
OR
IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE)

Any help would be much appreciated!

Thanks,
Jaret

Need help with vlookup nested function
 

Note: in Don's solution, both files will have to be open for INDIRECT to
work.

Pete

"Don Guillett" wrote in message
...
modify this to suit
=VLOOKUP(C2,INDIRECT("sheet" & IF(C3=B2,1,2) &"!a9:b11"),2,FALSE)

=VLOOKUP(b3,INDIRECT("'[mtn_ipbh_m40e_capacity_tool.xls]ero" &
IF(a2=r1,1,2) &"!p3:q5001"),2,FALSE)

Don Guillett
Microsoft MVP Excel
SalesAid Software

"mcmilja" wrote in message
...
Hello,

I need help with creating a vlookup nested function using the following
logic:

IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE)
OR
IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE)

Any help would be much appreciated!

Thanks,
Jaret

Need help with vlookup nested function
 

Good point
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pete_UK" wrote in message
...
Note: in Don's solution, both files will have to be open for INDIRECT to
work.

Pete

"Don Guillett" wrote in message
...
modify this to suit
=VLOOKUP(C2,INDIRECT("sheet" & IF(C3=B2,1,2) &"!a9:b11"),2,FALSE)

=VLOOKUP(b3,INDIRECT("'[mtn_ipbh_m40e_capacity_tool.xls]ero" &
IF(a2=r1,1,2) &"!p3:q5001"),2,FALSE)

Don Guillett
Microsoft MVP Excel
SalesAid Software

"mcmilja" wrote in message
...
Hello,

I need help with creating a vlookup nested function using the following
logic:

IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE)
OR
IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE)

Any help would be much appreciated!

Thanks,
Jaret

Need help with vlookup nested function
 

This worked like a champ! Thank you very much!

Jaret

"Pete_UK" wrote:

You could try this approach:

=IF(A2=R1,VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE),IF(A2=R2,VLOOKUP (B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE),"neither"))

Will return "neither" if A2 is not equal to R1 or R2. No further error
checking, so you will get #N/A if the item in B3 is not found in the table.

Hope this helps.

Pete

"mcmilja" wrote in message
...
Hello,

I need help with creating a vlookup nested function using the following
logic:

IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01
Interfaces'!$P$3:$Q$5001,2,FALSE)
OR
IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02
Interfaces'!$P$3:$Q$5001,2,FALSE)

Any help would be much appreciated!

Thanks,
Jaret