How to combine IF statement and Vlookup function?

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
 
M

Marcelo

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:
 
S

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_Assignments.xls!MTN_ER01_T1,1,),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top