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