Forum Discussion
Array concept and looping doubt
In attached excel you can find two columns of data where Column A- Industry Column B- Engine no In column F you can find the status of engine, here i need to get the status of engine output...
Nandhu19940 is this a class assignment? I ask because you say you have to use VBA when this is a simple VLOOKUP function that can be put in col C (e.g. =VLOOKUP(B2,$E$3:$F$10,2,FALSE) )
mtarler Thanks lot
Moreover array also i need to do , not know how to do that.
I just succeeded in stored the entire column values in array as variant but further i don't know how to proceed.
More doubts in using loop here in my array.