Hi all,
I have what I hope is an easy question.
I have the below code for checking if an order is urgent or not.
The way it works is that it checks order numbers on available stock in column C in one workbook and compares it to another workbook "HOTSPOTS" containing a list of all the urgent orders to determine which orders on the first workbook are urgent.
=IF(C8="","",IF(ISERROR(VLOOKUP(C8,[Hotspots.xlsm]HOTSPOTS!$R:$R,1,FALSE)),"NO","YES"))
If column C is missing an order number, then the result will be blank, if the result errors, then it will show as "NO" meaning that order is not on the hotspots list and is therefore not urgent and if no error occurs, this means that the order number is present on both workbooks and will show as "YES" as it is urgent.
My question is this, can I add to the formula an additional piece of code that will check the entry of another column at the same time?
That is to say that if the order number appears on both sheets and is therefore urgent, that it will then check if column "G" contains "YES" in that same row that the order number is found on in the "HOTSPOTS" workbook. Column "G" being yes means that the order is more urgent and therefore needs to result in "CRIT" being the result. If column "G" does not contain "YES" for that row, then the order is just urgent and the result should be "YES".
I have what I hope is an easy question.
I have the below code for checking if an order is urgent or not.
The way it works is that it checks order numbers on available stock in column C in one workbook and compares it to another workbook "HOTSPOTS" containing a list of all the urgent orders to determine which orders on the first workbook are urgent.
=IF(C8="","",IF(ISERROR(VLOOKUP(C8,[Hotspots.xlsm]HOTSPOTS!$R:$R,1,FALSE)),"NO","YES"))
If column C is missing an order number, then the result will be blank, if the result errors, then it will show as "NO" meaning that order is not on the hotspots list and is therefore not urgent and if no error occurs, this means that the order number is present on both workbooks and will show as "YES" as it is urgent.
My question is this, can I add to the formula an additional piece of code that will check the entry of another column at the same time?
That is to say that if the order number appears on both sheets and is therefore urgent, that it will then check if column "G" contains "YES" in that same row that the order number is found on in the "HOTSPOTS" workbook. Column "G" being yes means that the order is more urgent and therefore needs to result in "CRIT" being the result. If column "G" does not contain "YES" for that row, then the order is just urgent and the result should be "YES".
