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