I have two sheets,
sheet1 has three columns of data where A1 is "Problem#", B1 is "Group#" and C1 is "Symptom"
sheet2 has five columns of data, two of which contain the exact same columns of data from sheet1 where B1 is "Problem#" and C1 is "Group#"
I would like a macro that will populate a new column on sheet2 in E1 for "Symptom" when BOTH "Problem#" and "Group#" columns from sheet1 are matched with both "Problem#" and "Group#" columns from sheet2.
Please note that Problem# and Group# are numeric while Symptom is a text value
Any help here would be greatly appreciated!
Bookmarks