Thread: Need help with vlookup nested function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcmilja mcmilja is offline
external usenet poster
  
Posts: 35
Default 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

Reply With QuoteReply With Quote