View Single Post
  #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.