Hey Guys,
Column C contains the main criteria “enduse”
Sheet 2 contains a cross classification with “enduse” an “NAEnduse”
Sheet 1 also has “NAEnduse” and “NAAltEnduse”
I want to create a column called “Final NAenduse”
It will use the “enduse” with the cross classification on sheet 2
So if “enduse” is 51 the cross classification is saying 3 hence “Final NAenduse” will be 3
But it’s possible for the “NAEnduse” and “NAAltEnduse” to deviate from the cross classification
When this happens the “NAEnduse” and “NAAltEnduse” takes priority
In this case the “NAEnduse” on sheet 1 will take priority and be used for the “Final NAenduse”
See highlighted area for diversion
Column G is the expected result in “Final NAenduse” for the entire worksheet.
Thanks
Column C contains the main criteria “enduse”
Sheet 2 contains a cross classification with “enduse” an “NAEnduse”
Sheet 1 also has “NAEnduse” and “NAAltEnduse”
I want to create a column called “Final NAenduse”
It will use the “enduse” with the cross classification on sheet 2
So if “enduse” is 51 the cross classification is saying 3 hence “Final NAenduse” will be 3
But it’s possible for the “NAEnduse” and “NAAltEnduse” to deviate from the cross classification
When this happens the “NAEnduse” and “NAAltEnduse” takes priority
In this case the “NAEnduse” on sheet 1 will take priority and be used for the “Final NAenduse”
See highlighted area for diversion
Column G is the expected result in “Final NAenduse” for the entire worksheet.
Thanks