View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tombradshawuk tombradshawuk is offline
external usenet poster
 
Posts: 3
Default help with brackets

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