Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with array lookup and max
Ladies and Gentlemen,
If someone would assist me in adding a max formula to this array without adding any columns I would appreciate it greatly! {=INDEX($N$34:$V$35,2,MATCH(W32,$N$34:$V$34,0))} This formula is intended to look up all instances of Cell W32. The problem is an added search criteria in row 2 (Range N35:V35) of a number. I need the formula to select the largest number that corresponds (ie. directly below) all instances of the contents of cellW32 in row 1 (N34:V34). Hope thats understandable. - David |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with array lookup and max
Hi David
see response to your earlier posting =IF(COUNTIF($N$34:$V$34,X34),MAX(($N$34:$V$34=X34) *$N$35:$V$35),"") -- Regards Roger Govier "DavidFarnsworth" wrote in message ... Ladies and Gentlemen, If someone would assist me in adding a max formula to this array without adding any columns I would appreciate it greatly! {=INDEX($N$34:$V$35,2,MATCH(W32,$N$34:$V$34,0))} This formula is intended to look up all instances of Cell W32. The problem is an added search criteria in row 2 (Range N35:V35) of a number. I need the formula to select the largest number that corresponds (ie. directly below) all instances of the contents of cellW32 in row 1 (N34:V34). Hope thats understandable. - David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|