Taking your idea, I think jae ryu was looking more for a string of the form
"1988*0.77", rather than actually multiplying year values (if that's what
they are?):
=VLOOKUP(E1,$A$1:$C$21,2) & "*" &
ROUND(MAX(D1,VLOOKUP(E1,$A$1:$C$21,3))/MIN(D1,VLOOKUP(E1,$A$1:$C$21,3)),2)
placed in F1 and copied down (note yours should be put in F19 and copied up
and down!)
Pascal


"Mike Fogleman" wrote in message
...
How about a formula to put in F1 and copy it down?


=VLOOKUP(E19,$A$1:$C$21,2)*(MAX(D19,VLOOKUP(E19,$A $1:$C$21,3))/MIN(D19,VLOOK
UP(E19,$A$1:$C$21,3)))

Mike F
[snip]
be followed.
Col_F
1988*0.77 (here, 0.77=-0.27/-0.35)
1988*0.77 (here, 0.77=-0.27/-0.35)
1980*3.0 (here, 3=0.15/0.05)