Lookup question

[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?

 

[Peo Sjoblom]

Try


=LOOKUP(2,1/(Format!$A$2:$A$200=D3),$B$2:$B$200)




--


Regards,


Peo Sjoblom

 

[Aline]

Thank you for your response.

I tried before it did not work. I will try it again.

 

[Sheeloo]

What Peo has suggested should work. It did for me.