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!