Hi!!
I am looking for an excel fomula to accomplish the following. I have two cloumns with information and if I have matching value in the 2 columns I would like to assign a value to the corresponding cell otherwise it will update the cell with what's in column2.
Example:
Column1 Column2 Formula
-----------------------------------------------
Buffalo NewYork ChickenWings
Cleveland Ohio Ohio
Seattle Washington Washington
Baltimore Maryland Maryland
Buffalo NewYork ChickenWings
Houston Texas Texas
I have tried various combinations of IF, ISNA and VLOOKUP but somehow I am unable to get the above result. I would appreciate help to resolve this.
Thanks in advance!!
Cheers
Gary
I am looking for an excel fomula to accomplish the following. I have two cloumns with information and if I have matching value in the 2 columns I would like to assign a value to the corresponding cell otherwise it will update the cell with what's in column2.
Example:
Column1 Column2 Formula
-----------------------------------------------
Buffalo NewYork ChickenWings
Cleveland Ohio Ohio
Seattle Washington Washington
Baltimore Maryland Maryland
Buffalo NewYork ChickenWings
Houston Texas Texas
I have tried various combinations of IF, ISNA and VLOOKUP but somehow I am unable to get the above result. I would appreciate help to resolve this.
Thanks in advance!!
Cheers
Gary