Help with LOCalc formula

users
#1

Try this.

=IF(B1="","",OFFSET($Z$20,MATCH(B1,$B$20:$B$35,0)-1,25))

#2

Hi,
Bruce, Remy, Brian and Jim
Thank you for your kindness and answers.

Tonight while following the election on TV I'll have a lot to do when giving the VLOOKUP() a new try according to your advice.
I must have done bad thinking -- perhaps getting old.
Anyway I again learn a lot.
Best regards
Pertti