Hello,
I have a mission which requires me to compare values on two columns and
return a certain value on the third column. Let us say compare column A and
B first, and return certain value for each row on column C.
B column is the master column and for each cell on the column, it has
different filled colors, red or green.
After compares data on column A and column B, if the value matchs each other
and on B column that specific cell is green, it will return "Y" on column C.
If the value matches each other and on B column that specific cell is red,
it will return "N" on column C.
My hope is to use some functions/formula so I only need to do one return or
a few and drag it to the end and let it done automatically since column A
and B has too many inputs.
I know to use VLOOKUP funtion to compare two columns if the data matches
each other exactly.However, I have no idea how to reture to a certain value
based on the filled color for each cell on column B.(so far I have to
manually type it on each cell for column C, and it is very frustrating)
If it cannot be done, is there any alternate way to fix it? Thanks a lot for
all the kindly help!
V/R,