May 11 2020 07:39 AM
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 in Column C using VBA code
Let me know how to store column B in array and then looping thru each value to get desired output in Column C
How to make comparison here with looping each value from array with values from column F
Is there any way to write this in formula
May 11 2020 08:16 AM
@Nandhu19940you should read Chapter 6,7,8 to complete this job. This will help you to code your work.
https://excelsirji.com/vba-for-beginners/
Thanks
Kapil
May 11 2020 08:32 AM
@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) )
May 11 2020 08:58 AM
May 11 2020 07:35 PM - edited May 11 2020 07:37 PM
@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.