Targets may be set before the realized values hit, so maybe use

=INDEX($2:$2,1,MATCH(latest_realized,$3:$3,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stefi" wrote in message
...
Say your data are in row 2 and row 3, in columns A:L for 12 months, then
in column M
row 2 (target) =INDEX(A3:L3,1,COUNT(A2:L2))
row 3 (realized) =INDEX(A2:L2,1,COUNT(A2:L2))


Regards,
Stefi

"Lars" ezt írta:

I have a series of data in a two row and need to make a conditional
lookup.
The problem is, that a conditional formula is restricted to 7 arguments.

The problem:
I have two rows. In the upper row is a target value for each month and
in
the lower the realized value is entered. In a column i need: 1. the
latest
entered realized value 2. the target value corresponding to the latest
entered realized value.

I hope you can help