User Profile
2Dogs6
Copper Contributor
Joined Nov 17, 2020
User Widgets
Recent Discussions
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 less than $0 and some will have a cost equal to $0. Unfortunately some of the data being looked up from one sheet will not be listed in the lookup sheet. So I need the iferror to have a result of "No Data". But if the Lookup Value (column A) does exist and is equal to 0 then the result needs to state "Cancelled". For all other costs the result will be "Valid". There will be no blank data. Thank you for your help. =IFERROR(VLOOKUP($A2,Sheet2!$A:$C,2,0),"No Data") and =IF(VLOOKUP($A2,Sheet2!$A:$C,2,0)=0,"Cancelled","Valid")Solved42KViews0likes5Comments
Recent Blog Articles
No content to show