Display cell based on multiple cross-references
 

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!

Display cell based on multiple cross-references
 

=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)


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552456

Display cell based on multiple cross-references
 

Column A is numbers and the rows are unique AND it works like a charm! Thanks
a TON!

"kraljb" wrote:


=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)


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552456