Display cell based on multiple cross-references

P

Petee

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!
 
K

kraljb

=SUMPRODUCT(--(C1:C1000=H1),--(B1:B1000=H2),A1:A1000)

Although this only works as long as column A is numbers and there are
no duplicate rows (i.e. 2 rows with 799 and 103)
 
Top