I have over 1,000 rows with 3 columns of non-unique numbers/letters (no two
rows are entirely the same).
4 790 54
4 794 93
4 797 20
4 797 74X
4 799 103
5 511 93
5 511 120
5 520 74X
I have 2 cells that I will use to paste in numbers from another database:
H1=103
H2=799
I need a new cell query like:
If H1=ColumnC AND H2=ColumnB then display the value of ColumnA... (4 in this
example).
Please save me before I pull more hair out! Thanks!
Bookmarks