LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HLOOKUP using variable columns Chuka Excel Worksheet Functions 5 December 4th 08 11:40 PM
HOW DO I ADD ROWS WITH TWO TEXT VARIABLE 8A8Y8LUE Excel Discussion (Misc queries) 1 November 14th 08 06:02 PM
Using VLOOKUP or HLOOKUP to sum ROWS Browny Excel Discussion (Misc queries) 1 August 4th 08 04:43 AM
Using VLOOKUP or HLOOKUP to sum ROWS Max Excel Discussion (Misc queries) 0 August 4th 08 04:35 AM
sum and variable rows Jim Excel Worksheet Functions 4 September 7th 05 07:48 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"