Hi all
I am trying to look up the value in column I when:
Value in A2 matches Column G in "DataTab"
Value C1 (constant as column header) matches Column E in "DataTab"
DataTab
and then on the sheet I want the results displayed
I am trying to look up the value in column I when:
Value in A2 matches Column G in "DataTab"
Value C1 (constant as column header) matches Column E in "DataTab"
DataTab
Column E (Add/Remove) | Column F | Column G (Reference) | Column H | Column I |
Remove | abcdef | 12345 | xxxxxxxx | Circle |
Add | abcdef | 12345 | xxxxxxxx | Circular |
Remove | ghijkl | 12346 | xxxxxxxx | Rectangle |
Add | ghijkl | 12346 | xxxxxxxx | Rectangular |
and then on the sheet I want the results displayed
Column A (Reference) | Column B (Data_1) | Column C (REMOVE) | Column D (ADD) | |
12345 | abcdef | Circle | Circular | |
12346 | ghijkl | Rectangle | Recttangular | |