[tombradshawuk]

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

[Allllen]

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

[tombradshawuk]

Thats great thanks!

"Allllen" wrote:

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

[Sandy Mann]

tombradshawuk, (if you are still around),

When I started writing formulas I would copy and print out a formula on to
paper and then connect up the ends of the brackets, (parentheses to our
American friends), starting from the inner most ones to make ovals. That
way it became clear where my mistake was.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"tombradshawuk" wrote in message
...
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