help with brackets

T

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
 
A

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),"")
 
S

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top