IF([Cell_Path_Assignments.xls]MTN_179_CD!R3="ER01",VLOOKUP(J2,Cell_Path_Assignme nts.xls!MTN_ER01_T1,1,FALSE),false)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"mcmilja" escreveu:

Hello,

How can I combine an IF statement and Vlookup function?
I need to create a nested funciton where if cell R3 contains the text "ER01"
then Vlookup list MTN_ER_T1.

I need to combine the 2 functions below:
=IF([Cell_Path_Assignments.xls]MTN_179_CD!R3="ER01"
then
=VLOOKUP(J2,Cell_Path_Assignments.xls!MTN_ER01_T1, 1,FALSE)

Thanks,
Jaret