LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Looking up values in multiple rows

Hi there,

I need to have a vlookup or something that works across rows.

For example, I have column A representing time, with A1 through to Axxxx
with each cell showing a time for a specific date. So for June 1 we would see
the times 08:00, 08:30, 09:00, etc. Then for June 2 we would see the times
08:00, 08:30, 09:00, etc.. For the entire month these same times are noted.
Column C is the column that has the data that I want, but I only want a
specific time.

How do I set this up so that my formula gives me the column C data for 12:30
for every day in June.

Thanks,
Marie
 
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
Displaying Multiple Values without using Macros or ROWS function ltzhao Excel Worksheet Functions 4 March 16th 09 04:13 PM
How to retrieve multiple values in multiple rows with one criteria bac Excel Discussion (Misc queries) 2 June 15th 07 08:57 PM
Looking up multiple items and suming the values on their rows walkingmac Excel Discussion (Misc queries) 2 March 6th 06 01:49 PM
Count on multiple values with duplicate rows Carla Excel Worksheet Functions 1 November 22nd 05 09:25 PM
counting rows with same values for multiple values Jon Viehe New Users to Excel 4 September 1st 05 03:49 PM


All times are GMT +1. The time now is 07:17 PM.

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

About Us

"It's about Microsoft Excel"