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

Similar Threads

Need help with vlookup nested function 5
Can I add a formula or function to Vlookup? 1
Need help with nested funciton using vlookup 6
How do I combine IF(ISNUMBER(SEARCH and VLOOKUP( formulas 0
=IF and VLOOKUP 2
IF statement with multiple VLOOKUPs 0
Page numbering with Merged Document and IF statements 1
Word macro that can call cells out of Excel for a find and replace 0

Top