Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) | |||
Multiple or Variable cell references in Solver (Excel 97) | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
using multiple split cell references in linest | Excel Worksheet Functions |