LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default Lookup range help

I am trying to find out if there is a way to return a specified column in a
vlookup formula, with a changing selection. For example...

Month Jan Feb Mar Apr

Cust
1 20 15 25 30
2 10 8 30 15
3 45 55 63 49

In my formula I would like the Month column to change, when I specify what
month I am looking for. I am trying to see if I can keep the formula the
same and change the month in an index sheet, and have my lookup reference the
index sheet.

 
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
3 column lookup within range cmgmyr Excel Worksheet Functions 2 January 16th 08 09:29 PM
help with lookup and range Mona Excel Worksheet Functions 3 January 10th 08 11:48 PM
Lookup in a range. Paul Excel Discussion (Misc queries) 4 February 1st 06 08:51 PM
Range Lookup Jake Excel Discussion (Misc queries) 2 April 28th 05 11:02 PM
Range Lookup? Is there such a thing like this? Michael Saffer Excel Worksheet Functions 2 April 8th 05 05:45 PM


All times are GMT +1. The time now is 12:42 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"