Blank cell is denoted by " ".
I want to match the value in column 1 with the same value in either column 2 or 3. I would like to use the row of the matched result to output the value in column 4.
What i have:
A A B 123
B C D 456
C E " " 789
D F G 987
E H I 654
F J K 321
Desired outputRows 1-6 A-F are being matched)
123
123
456
456
789
987
I've tried using the match and index functions but realized that match is only for one dimensional arrays. I worked it around several ways but a solution is escaping me right now. Any help would be appriceated. I think a VBA solution might be easier but i'm just starting to learn.
Thanks
Bookmarks