Forum Discussion
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...
=IFERROR(IF(VLOOKUP($A2,Sheet2!$A:$C,2,0)=0,"Cancelled","Valid"),"No Data")
Does this return the intended results?
=IFERROR(IF(VLOOKUP($A2,Sheet2!$A:$C,2,0)=0,"Cancelled","Valid"),"No Data")
Does this return the intended results?
- I knew it was an easy answer just couldn't get anything to show up in a google search. This worked perfectly. Thank you.
