Lookup question

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top