View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 390
Default HLOOKUP with variable rows

Hi Guys,

I am using an HLOOKUP to find a certain cell in a row of column headings and
then return the information under that column heading in the same row of a
table, so that as i fill down, the formula will just return the corresponding
cell in the same row as the "look up value". Is there anyway i can ask excel
to do this please?

Thanks for you help,

Max