A
Aline
I’m having problems this the following formula:
=LOOKUP(2,1/(Format!A2:A200=D3),B2:B200)
What I want is that only D3 becomes D4, D5, D6... and the rest stays the
same when I copy the formula for the rest of rows:
=LOOKUP(2,1/(Format!A2:A200=D4),B2:B200),
=LOOKUP(2,1/(Format!A2:A200=D5),B2:B200),
=LOOKUP(2,1/(Format!A2:A200=D6),B2:B200),
....
(But it instead it becomes:
=LOOKUP(2,1/(Format!A3:A200=D4),B3:B200),
=LOOKUP(2,1/(Format!A4:A200=D5),B4:B200),
=LOOKUP(2,1/(Format!A5:A200=D6),B5:B200),
....
Any suggestions?
=LOOKUP(2,1/(Format!A2:A200=D3),B2:B200)
What I want is that only D3 becomes D4, D5, D6... and the rest stays the
same when I copy the formula for the rest of rows:
=LOOKUP(2,1/(Format!A2:A200=D4),B2:B200),
=LOOKUP(2,1/(Format!A2:A200=D5),B2:B200),
=LOOKUP(2,1/(Format!A2:A200=D6),B2:B200),
....
(But it instead it becomes:
=LOOKUP(2,1/(Format!A3:A200=D4),B3:B200),
=LOOKUP(2,1/(Format!A4:A200=D5),B4:B200),
=LOOKUP(2,1/(Format!A5:A200=D6),B5:B200),
....
Any suggestions?