LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JEB JEB is offline
external usenet poster
 
Posts: 40
Default vlookup, indexing, oh my....

Totally lost on this one.

I have a date values in Col I that are fed in from another sheet. These
dates may be typed in by a user in any format, but the critical info the year
and the month.

I have a series of months and years listed in Col A with corresponding info
in Col B that is only pertinent to that info in Col B. (Col B is the average
monthly outdoor temperature).

In another Column (let's call it M), I want to "index/lookup" the month and
year in Col I, match it with the month and year in Col A, and return the
value in Col B.

Any ideas?
 
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
Indexing Anto111 Excel Discussion (Misc queries) 1 July 26th 08 08:01 PM
Indexing of Name Charlie Excel Worksheet Functions 1 April 5th 06 01:33 PM
Indexing an Array with VLOOKUP Joe Blow Excel Worksheet Functions 1 March 14th 05 09:23 PM
Vlookup and Indexing in excel CLSCHWIES Excel Worksheet Functions 2 December 4th 04 01:57 AM
Vlookup - indexing Josef.angel Excel Worksheet Functions 7 October 29th 04 08:50 AM


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