How to combine IF statement and Vlookup function?

  • Thread starter Thread starter mcmilja
  • Start date Start date
M

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
 
IF([Cell_Path_Assignments.xls]MTN_179_CD!R3="ER01",VLOOKUP(J2,Cell_Path_Assignments.xls!MTN_ER01_T1,1,FALSE),false)

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



"mcmilja" escreveu:
 
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_Assignments.xls!MTN_ER01_T1,1,),"")
 
Back
Top