[mcmilja]

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

[Marcelo]

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

[ShaneDevenshire]

Hi,

You can shorten the standard VLOOKUP function by replacing the TRUE or FALSE
arguments with 1 or 0 OR leave out the last argument altogether for TRUE and
enter only a comma for FALSE:


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

--
Cheers,
Shane Devenshire
Microsoft Excel MVP


"mcmilja" wrote:

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