On 2002-10-29 21:45, PaddyD wrote:
with the posted sample in a1:c8,
=INDEX(C1:C8,MATCH("a",IF(B1:B8="e",A1:A8),0))
this needs to be array entered (using control + shift + enter, not just enter).
see
http://www.mrexcel.com/board/viewtopic.php?topic=21288&forum=2
for more info.
paddy
On 2002-10-29 23:26, Yogi Anand wrote:
Hi gopa:
Or the following non-array formula:
=VLOOKUP(B10,{"a",1;"b",2;"c",3;"d",4},2,0)+MATCH(B11,B1:B8,0)-1
[...]
On 2002-10-29 23:50, IML wrote:
what about a good, old fashion sumproduct?
[...]