Hi Tom,

=IF(ABS(VLOOKUP($B3,Sheet2!$A$2:$G$8,7,FALSE)-$H3)<=21,VLOOKUP($B3,Sheet2!$A$2:$H$8,8,FALSE),"")
--
Allllen


"tombradshawuk" wrote:

i think i just need the brackets in the right place for thhis but im not
sure? I may well have made a complete hash of it.

=IF(ABS(VLOOKUP($B3,Sheet2!$A$2:$G$7,7,FALSE)-$H3)<=21,(VLOOKUP($B3,Sheet2!$A$2:$H$7,8,FALSE),"" )

Any suggestions greatfuly appreciated