Forum Discussion
How to check if a cell matches another, and if it matches, to match another, and return the column.
Rather lengthy title, but i'll break it down. Workbook A contains 2 sheets. Sheet 1 contains 2 columns in C and D. Column C has names of headers while column D has the abbreviation form of the heade...
millennnn Try by making both references to "Directory" columns C and D absolute for both the column AND row part:
$C$4:$C$60
$D$4:$D$60