Thread: hlookup- move range by 2 rows with fill.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_37_] barry houdini[_37_] is offline
external usenet poster
  
Posts: 10
Default hlookup- move range by 2 rows with fill.
So it looks like you want the first formula in B3 copied down, if so
try

=HLOOKUP(OFFSET('Hlookup table'!C$2,(ROWS(B$3:B3)-1)*2,0),OFFSET
('Hlookup table'!D$2:O$3,(ROWS(B$3:B3)-1)*2,0),2)

Reply With QuoteReply With Quote