Multiple results from If or Lookup...

N

NetWave128

I need to lookup a range and return another value...The problem is the
range is in multiple Rows...as well as the return value being in
muliple rows... Here is my equation:


=IF(T8=K52,LOOKUP(K52,T8,T7),IF(K52=D19:T19,LOOKUP(K52,D19:T19,D18:T18),IF(K52=D30:E30,LOOKUP(K52,D30:E30,D29:E29),Not
Found)))

Returns #Value
 
Top