Forum Discussion

2Dogs6's avatar
2Dogs6
Copper Contributor
Sep 21, 2023
Solved

Combine IF(Vlookup and IFERROR(Vlookup

Is it possible to combine the two vlookup formulas listed below?  I have tried so many different ways with no success. I am using Microsoft Excel 2016.    Some of the data will have costs more or l...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Sep 21, 2023

    2Dogs6 

    =IFERROR(IF(VLOOKUP($A2,Sheet2!$A:$C,2,0)=0,"Cancelled","Valid"),"No Data")

     

    Does this return the intended results?

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 21, 2023

2Dogs6 

Perhaps

=IFNA( IF(VLOOKUP($A1,Sheet2!$A:$C,2,0)=0,"Cancelled","Valid"), "No Data" )
2Dogs6's avatar
2Dogs6
Copper Contributor
Sep 21, 2023
This one worked perfectly as well. Thank you.

Resources